Pepe
Pepe

Reputation: 85

Issues exporting SSRS to CSV with textbox names

So I'm trying to export my SSRS to .CSV. The layout of my report is like this: As you can see, many expressions and whatnot

Everything does work fine, on my VS. However, when comes the time to generate it I get this:

enter image description here

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

Answers (1)

niktrs
niktrs

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

Related Questions