Reputation: 85
So I'm trying to export my SSRS to .CSV. The layout of my report is like this:
Everything does work fine, on my VS. However, when comes the time to generate it I get this:
I've read a few other post on Stack Overflow about how I can change my SSRS config for noheaders and ASCII. Thing is, people tried to set column names programatically, but here I only have expressions for cell contents and a current layout. Is there a way to make my CSV lay out look like my reportbuilder layout? Or is my problem the same as when people try to set the column programatically
Upvotes: 1
Views: 6041
Reputation: 10066
For each data field you want to export set the DataElementName to match the field title and set the value to the DataElementOutput to output the field. For the header textboxes set the DataElementOutput to NoOutput.
For more detail check the following microsoft link
https://msdn.microsoft.com/en-us/library/dd255251.aspx
Upvotes: 3