Post reply

SSRS - Export report into CSV File

  • July 20, 2011 at 9:25 am

    #244682

    In SSRS Reporting Services, after design a report, i saw Preview. Report is displaying properly. This report contains 12 columns.

    But, while i try to export the report into CSV file, it displays only 8 columns.

    Remaining 4 columns not displays.

    I dont know why it is.

    Need help to solve this.

  • July 20, 2011 at 9:59 am

    #1355795

    Guesses...

    do you have hidden columns in the report?

    Do you have calculated columns?

    do you have matrixes or groups to create new columns?

    AFAIK, csv exports the raw data, nothing really formatted.

  • July 20, 2011 at 10:30 am

    #1355841

    Also a guess, but SSRS can be particular about formatting. Are the last four columns missing? If so, it may be that you need to choose a different page layout or print format. You may be able to view them, but the columns are really off the page, depending on your preview options.

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • July 20, 2011 at 10:35 am

    #1355848

    Thank you Ninja and for your replies.

    Now it's working.

    Problem is i tried grouped fields to display, as per ninja's reply, i remove the grouping,

    then i tried and got the result.

    Thanks again.

  • July 20, 2011 at 10:39 am

    #1355853

    visual.prabu (7/20/2011)

    Thank you Ninja and for your replies.

    Now it's working.

    Problem is i tried grouped fields to display, as per ninja's reply, i remove the grouping,

    then i tried and got the result.

    Thanks again.

    Could you please confirm that the csv export is basically raw data only? I'd love to know for sure if you have 2 minutes to confirm with a test (something simple like doing YourColumn * 0 and see wether you get 0s all the way or other numbers).

  • July 21, 2011 at 2:49 am

    #1356209

    I have no numeric columns in my report, it contains only string and date.

    I guess i can't do what you suggested.

    Any other idea...?

    Note: There is no raw data, all are comes from database.

  • July 21, 2011 at 5:01 am

    #1356256

    visual.prabu (7/21/2011)

    I have no numeric columns in my report, it contains only string and date.

    I guess i can't do what you suggested.

    Any other idea...?

    Note: There is no raw data, all are comes from database.

    What I meant by raw data is the data that is the the dataset, without any transformation, calculations, formating or groupings.

    You could do the same test by putting a column with YEAR(DateColumn). Then see if the csv contains the year or the full date.

    Thanks in advance.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply