Last post Aug 01, 2014 03:15 AM by jjkk
Jul 29, 2014 02:57 PMemail@example.com|LINK
I have this report. I have this aspx page, users can make the selection in the drop down boxes and depending on the users selection, I am calling this sql report by passing the parameters.
When the users make the selection, I can view the report on web page, but when I do the export to CSV, some of the columns do not get exported to csv. If I set the DataElementOutput property to "Output" then I can see the column contents in CSV, but when
it is set to auto then I don't see the contents for some columns. The problems is if I set the property to DataElementOutput then the contents of that column show in the output all the time no matter if the user select that column in the aspx page to view
in the report or not. I can see that column to be exported in CSV all the time. I only want those columns to be exported to CSV that I am seeing on my report page.
I also checked the hidden property of the text box and that is set to false for all the text boxes.
Any help will be greatly appreciated.
Jul 29, 2014 03:09 PMfirstname.lastname@example.org|LINK
any suggestion will be greatly appreciated. I didn't create this report so there might be some options that I might be overlooking that is making the columns not exporting to Excel.
Aug 01, 2014 03:15 AM|jjkk|LINK
Exporting to a CSV File (Report Builder and SSRS)