Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nidabp
Starting Member
15 Posts |
 Posted - 2010-12-08 : 02:11:23
|
Hi,
I am trying to format my text as follows in a single text box(SSRS2005)
test1: value1
testing: value2
test3: value3
My textbox.value = space(5) + "test1:" + space(1) + "value1" + VBCRLF +space(2) + "testing:" + space(1) + "value2" + VBCRLF + space(5) + "test3:" + space(1) + "value3"
VBCRLF works fine..
But the spaces are not getting displayed.
I tried using functions like Padleft,Space,StdUp, but could not get that output.
Thanx
But the spaces are not getting displayed
|
|
|
tripleZ
Starting Member
7 Posts |
Posted - 2010-12-15 : 16:55:27
|
This worked for me. I substituted parameter values for your "value1". Here is my string:
=space(5)+"Value1:"+space(1)+Parameters!OutputType.Value+VBCRLF+space(5)+"Value2:"+space(1)+Parameters!OutputType.Value
If you Value1 is a field or part of dataset, remove the double quotes for starters.
Mike
Mike |
 |
|
|
|
|
|
adding spaces to the textbox.value