SSRS 2008 Output to CSV missing data
I have an SSRS 2008 repport that when viewed on the screen or sent to a spreadsheet will show all the data. However, if I output it to a CSV file, the header field values appear the name of the texboxes. See attached csv file. How do I get all the values to appear in the CSV file.
PrintRFQs.csv
PrintRFQs.csv
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Yup. The first row is the header details of the table. The second row shows the data that will come from your backend . So, from 2nd onwards you are getting data but first is what you set at the BIDS. You are just getting the name of the textbox from the second row.
Was the issue solved?
ASKER
I will get back on this on Monday.
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.
10K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
I have a header section with data fields that are expressions. They do not appear at all in the CSV version.
Additionally, in the example I included here I have two rows in the tablix. The first row is what you are seeing with the text box names. The second row is the actual data. So why one row print "[textbox']" and the other printed data is a mystery.