Prev: How to create this grouping in ssrs?
Next: Multi-level grouping drill down SSRS report
From: Michael Buller on 20 Jan 2010 16:15
I am trying to create an address block in a letter generating report. I use
VbCrLf to get the address lines on the correct lines. When you export to PDF
from the reports intranet, it comes up as all squares. I tried replacing the
VbCrLf with char(13) + char(10) and it does the same thing. I have tested
this same functionality with SQL Server 2008 and I have no issues. Is there
a fix or something that I am missing for this?
From: Andrew Karcher [SQL] on 20 Jan 2010 21:14
Michael,

I was unable to reproduce what you are seeing. All the following
worked for me when exported to PDF both in Report Designer and when
deployed to the Server.

="This is Text" & VbCrLf & "the next line"

="This is Text" + vbCrLf + "the next line"

The following also worked although when I deployed the report to the
Server the HTML did not display correctly, but the PDF rendered
correctly

= "This is Text" + chr(10) + chr(13) + "the next line"

Are you up to date on all your service packs?

Andrew
SQL Server MVP

On Wed, 20 Jan 2010 13:15:01 -0800, Michael Buller
<MichaelBuller(a)discussions.microsoft.com> wrote:

>I am trying to create an address block in a letter generating report. I use
>VbCrLf to get the address lines on the correct lines. When you export to PDF
>from the reports intranet, it comes up as all squares. I tried replacing the
>VbCrLf with char(13) + char(10) and it does the same thing. I have tested
>this same functionality with SQL Server 2008 and I have no issues. Is there
>a fix or something that I am missing for this?
 | 
Pages: 1
Prev: How to create this grouping in ssrs?
Next: Multi-level grouping drill down SSRS report