SSRS 2008 Output to CSV missing data

Posted on 2011-10-06
Last Modified: 2012-05-12
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.
Question by:rwheeler23
    LVL 25

    Accepted Solution

    Okay. This is an issue with the way the report is rendered(exported).
    In Excel\PDF\etc format you are seeing the header name being the same as shown in the report because it is created in the way itself.
    With CSV format, you didn't get the value because, in CSV format, the values of the header is not the same as the table header values, but, Its the name of the text box where your data is being fetched while you have desinged the report. I don't know much about the rendering process but in case I will find, I will do post. Or if someone else have the time and would like to share, I will love to read it.
    For now, you can do the following thing.

    1. Go to the property of textboxes, here in your case, it is
         This textboxes must the exactly below the header columns in your report.

    2. Go to General tab

    3. Change the name of the textbox to the respective header names they represent.
        For e.g if TextBox14 represents StudID, change the name to StudID

    This should solve the issue.

    Author Comment

    I just noticed bigger problems with this.
    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.
    LVL 25

    Expert Comment

    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.
    LVL 25

    Expert Comment

    Was the issue solved?

    Author Comment

    I will get back on this on Monday.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction Earlier I wrote an article about the new lookup functions ( that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now