Post reply

Extra Row in Report Save as CSV

  • April 23, 2020 at 11:01 pm

    #3745841

    Using SSRS 2014, I'm getting an extra row at the bottom of the file when I save a report as a CSV file.

    Is there something I can add to the reportserver.config file?

    Thank you

     

  • April 24, 2020 at 11:10 pm

    #3746214

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • April 25, 2020 at 5:15 pm

    #3746331

    Is there a blank footer row in the report?  Those will often look invisible when you are previewing or running the report, but will show up when you export it.  Deleting that footer in Visual Studio (or whatever report designer you're using) is how I usually make the blank row at the end of a csv (or Excel) go away.

  • April 25, 2020 at 6:54 pm

    #3746342

    Thank you for the response. Unfortunately, I do not have any footers. I'm including a screenshot of the report design.

    To be clear, when selecting the option to Save as CSV, there is a blank row at the end of the file.

    Report Design

    Shown here is the issue. Row 34 needs to go away.

    CSV Output

  • April 25, 2020 at 7:10 pm

    #3746343

    google is your friend - sadly most people don't use it.

    https://stackoverflow.com/questions/4095627/blank-lines-at-end-of-ssrs-csv-export

Viewing 5 posts - 1 through 4 (of 4 total)

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