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.

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.