sql server reporting services: NewLine and Carriage return issue in PDF format -- sql server reporting services

NewLine and Carriage return issue in PDF format

Nergock NO[at]SPAM gmail.com
3/28/2006 3:31:15 PM

sql server reporting services:

If I insert the following expression in a textbox it will display
correctly in HTML format but not in PDF format. Can anyone show me how
to accomplish the same thing so that it will display correctly in both
HTML and and PDF format.

vbCrLf & vbCrLf & vbCrLf & "My Text"

In HTML format, it will display "My Text" on the 4th "row". Whereas in
PDF format, it displays "My Text" on the first row of the textbox.

Re: NewLine and Carriage return issue in PDF format

Rodney Landrum
3/29/2006 3:20:07 PM

This has to be an issue (bug) with PDF and how it formats initial blank
space before the literal text. I am not sure if this is addressed in a
service pack for 2000 or in 2005 (I am using 2000 to test this) but here is
a workaround that I found that places an ASCII record seperator in the first
position before the CRLF's as:

=CHR(30)&vbCrLf & vbCrLf & vbCrLf & "My Text"

That should work.

Rodney Landrum

[quoted text, click to view]