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.ThanxBut 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.ValueIf you Value1 is a field or part of dataset, remove the double quotes for starters.MikeMike |
 |
|
|
|
|
|
adding spaces to the textbox.value