Double line spacing in SSRS
How do I achieve double spacing of lines in a large text box in SSRS?Thanks
March 3rd, 2010 4:36pm
This seems like it should be a simple problem to fix. No one knows how to achieve double line spacing in a text box in SSRS? One co-worker is telling me that it cannot be done. Really???
Free Windows Admin Tool Kit Click here and download it now
March 3rd, 2010 6:31pm
Hi bagman3rd,You want to double the space of lines in a textbox in SSRS.As we know ,there are several kinds of Line Spacing in the word document ,like single,1.5 lines ,double, multiple... While there is no such a property in SSRS . So you need to do the converting by yourself.For example, textbox's expression is:It is sunny todayI want to swim!There is only a single line space, so you can do like this to double it:Click the textbox's Expression, then change it to="It is sunny today" + vbCrLf +vbCrLf + "I want to swim!"then the document will be displaced like this which you want to see,
It is sunny today
I want to swim!
BTW: you need to specify where you want the text to start from a new line and ensure the textbox’s CanGrow property is set to trueSimply use the visual basic constant vbCrLf which performs Line Feed functions that makes text come after it to start in a new line. Add more vbCrLf to add more blank lines.
Best regards!
challen Fu
March 5th, 2010 11:42am
use padding .this may help youthanks and regardsRazzakRazzak Sayyed
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2010 11:50am
You can set the LineHeight property of the textbox to adjust line spacing, This is in font point, so if you're using 10pt font, set LineHeight to 20pt for double spacing. Unfortunately it appears to be a bug (or feature?) that this property only affects
the report when it's exported to HTML format--seriously, try it. Any other rendering format will simply ignore this property.
If you think this is silly, like I do, vote it up here as something MS should fix:
https://connect.microsoft.com/SQLServer/feedback/details/557661/line-spacing-options-for-ssrs?wa=wsignin1.0
October 1st, 2010 7:25pm