question

SSGC avatar image
SSGC asked

SSRS Report export to csv file with multiple sheets in one file

Can someone help me for a SSRS 2008 report with multiple tabs -sheets. I can export it for Excel file no problem. Excel file shown multiple tabs. When I try export report to a CSV file. it only give one tab. When I use excel to open this CSV file, the report format is not right second tab's data messed up with 1st tab's data. Is it possible export SSRS 2008 report to a CSV file, when use excel to open it still have multiple tabs? Thanks.
excelssrs-2008-r2csv
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
west007 avatar image
west007 answered
Hi No, csv is a textfile. Purpose i.e. to transfer one table. What is your reason not to use excel?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SSGC avatar image SSGC commented ·
Hi, Thank you for your input. The Excel file too large to send the email. (30mb file, zip file 9mb, csv file only 14mb, zip 3mb). The 9 MB zip file I can send by my outlook email, but my auto send email job cannot handle it.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.