Home |
Search |
Today's Posts |
#1
|
|||
|
|||
?? Extra blank lines in 'address' cell after exporting to Excel
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: 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 Is there a way to update the address column to remove these blank lines? I have attempted various formatting tricks in SQL Reporting Services and nothing seems to work. So, I thought there might be a way to export the data to Excel then update that column to remove the blank lines. Any help would be welcome... Hadyn |
#2
|
|||
|
|||
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: |
#3
|
|||
|
|||
Thanks. People in the company are running these reports individually and
don't have the ability to run the required SQL queries, so I need to continue with the Report Service. They need the to run the report and export it to Excel. I thought there might be a way to update the Excel column to remove additional lines in the cell after they do the export. Hadyn "arunkhemlai" wrote: 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: |
#5
|
|||
|
|||
Hadyn
See one possible at your first post. Gord Dibben Excel MVP On Fri, 15 Apr 2005 12:55:02 -0700, "Hadyn Pkok" wrote: Thanks. People in the company are running these reports individually and don't have the ability to run the required SQL queries, so I need to continue with the Report Service. They need the to run the report and export it to Excel. I thought there might be a way to update the Excel column to remove additional lines in the cell after they do the export. Hadyn "arunkhemlai" wrote: 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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) |