question

summoningknoweldge-4008 avatar image
0 Votes"
summoningknoweldge-4008 asked Joyzhao-MSFT edited

CSV export gets ruined, rows become columns

Here is my data

204050-image.png

And this is my SSRS report. It is a table with no groupings, just showing the 3 colums. I right clicked on me detail colum and insert row -> inside group - below.
I created row 6,7 and 8 because I use the SWITCH function to do some calculations to get the totals.

204070-image.png


Now the issue is that the report renders good when I run it. But when I export to CSV, it looks like this:
204058-image.png


The rows that I insert, they show up as columns and so my export gets ruined. How can I export them correctly?


sql-server-reporting-services
image.png (7.0 KiB)
image.png (4.6 KiB)
image.png (11.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @summoningknoweldge-4008 ,
This may be due to the specific behavior of exporting CSV. Such as subtotals ignored; hierarchies of hierarchical and grouped data, etc. Please check : Export a paginated report to a CSV file (Report Builder).
Best Regards,
Joy


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I right clicked on me detail colum and insert row -> inside group - below

If so, a new row will be inserted under each detail row.

204494-image.png

This doesn't seem to match the table you showed me.
I'm guessing that you are inserting rows outside the group so that the export CSV is not well formatted.


0 Votes 0 ·
image.png (15.3 KiB)