SSRS report export to Excel

• sql_ques

  SSCommitted

  Points: 1546

  More actions

  April 24, 2012 at 4:39 am

  #254635

  Hi,

  When I export SSRS report (2008 report server) to excel the formatting is not the same as in report server. The rows are merged and collapsed. Is there a way to maintain the formatting when exporting reports to excel.

  Please help.

  Thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 24, 2012 at 10:53 am

  #1478395

  sql_ques (4/24/2012)

  ---

  Hi,

  When I export SSRS report (2008 report server) to excel the formatting is not the same as in report server. The rows are merged and collapsed. Is there a way to maintain the formatting when exporting reports to excel.

  Please help.

  Thanks

  It depends on how the report is formatted as to how it will look in Excel. Same with PDF. It's a trial and error type thing unfortunately, as most display issues are.

  You'll need to modify the layout of the report such that it is acceptable when rendered in the SSRS Report Viewer, as well as in Excel.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Andy Hyslop

  SSCrazy Eights

  Points: 9198

  More actions

  April 25, 2012 at 2:42 am

  #1478762

  opc.three (4/24/2012)

  ---

  sql_ques (4/24/2012)

  ---

  Hi,

  When I export SSRS report (2008 report server) to excel the formatting is not the same as in report server. The rows are merged and collapsed. Is there a way to maintain the formatting when exporting reports to excel.

  Please help.

  Thanks

  It depends on how the report is formatted as to how it will look in Excel. Same with PDF. It's a trial and error type thing unfortunately, as most display issues are.

  You'll need to modify the layout of the report such that it is acceptable when rendered in the SSRS Report Viewer, as well as in Excel.

  +1

  In my experience SSRS is a little "twitchy" when it come to exporting reports

  Any images or text boxes ect that you have on your report will cause cells to merge upon the export to Excel

  Andy

  ==========================================================================================================================
  A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe