"Hadyn Pkok" wrote:

> OS = XP Pro latest sp, MS Office 2003 Pro latest sp
>
> I am using SQL Reporting Services (sp1) to export data to Excel. My stored
> proc requires a case statement with carriage returns to format Address data.
> I have also deleted the carriage returns from the stored proc and written an
> expression in the field using vbCrLf, but with the same results in both cases
> (posted below).
>
> For instance the IE report view looks correct as follows:
>
> SRT: ATTN: Sales
> 1603 Plasma Ave
> Stonewashed, IL 60135
>
> When I export the report to Excel, the cell containing the address info gets
> formatted with a blank line (within the cell) between each address line. For
> instance:
>
> SRT: ATTN: Sales
>
> 1603 Plasma Ave
>
> Stonewashed, IL 60135
>
> I am familiar with typical export issues related to Excel, but would very
> much like to solve this issue since the rendering undermines the utility of
> the report for the people receiving it. There are enough records to make a
> manual update futile.
>
> Any help would be welcome...
>