Hi,

I don't know much about the reporting services, so can't address your
question.
But if it's possible for you not to use it, you can try to use excel to
IMPORT data from sql instead; it may of may not help.

arunkhemlai

"Hadyn Pkok" wrote:

OS = XP Pro latest sp; MSOffice Pro 2003 latest sp

I am using SQL Reporting Services (Sp1) to export data to Excel. The SQL
query grabbing the data requires a case statement with carriage returns to
format Address data. For instance the output looks as follows: