Here is my data
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.
Now the issue is that the report renders good when I run it. But when I export to CSV, it looks like this:
The rows that I insert, they show up as columns and so my export gets ruined. How can I export them correctly?