Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

export ssrs report in Excel: Failure of the Format Cells Expand / Collapse
Author
Message
Posted Tuesday, October 22, 2013 6:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 10:56 AM
Points: 6, Visits: 21
Hi all,
When I export a report to an Excel file, SSRS does not respect the order of the cells, so I'm left with a column that is exported as two or more cells. as shown on the pictures:



is there a trick to export to a good format??

Thank you for your answers
Post #1507094
Posted Tuesday, October 22, 2013 8:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, August 10, 2014 6:47 PM
Points: 125, Visits: 266
The merged cells in an Excel export from SSRS are generally caused by report titles or text boxes that do not exactly line up with the column breaks in the tablix. To avoid the extra columns line up all items outside the tablix with a grid line within the tablix.

SSRS 2012 introduced Globals!RenderFormat.Name to allow you to suppress titles on export to Excel.
Post #1507183
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse