SSRS report export to Excel

  • Hi,

    When I export my SSRS report to excel, the formatting is not the same as in the report server. The rows are merged, rows are collapsed. Is there a way to mantain the formatting when exporting reports to excel?

    Thank you

  • I often get export issues when my report elements don't align well.

    Best thing to do is get the report in BIDS and make sure that everything conforms to a nice grid so that titles don't end in the middle of columns and any elements to the right of your table match to row heights.

    This should hopefully cut down many of your issues as the Excel export tries to be helpful and keep everything looking like it does on the browser which causes some really bizarre merging and resizing of cells to try and get everything to look the same.

Viewing 2 posts - 1 through 1 (of 1 total)

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