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

SSRS, export to Excel to fit into single page, Report Properties margins or local Excel Margings, who takes over?? Expand / Collapse
Author
Message
Posted Wednesday, December 4, 2013 2:48 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:19 AM
Points: 150, Visits: 370
Hi,
Ultimately I want to have report with email subscription to fit into single page, tried it all changing Margins in Report/ R Properties, but after export to excel, I don't see SSRS setting be in effect. I think it's still local Excel settings, am I right ? After opening, I still need to apply custom margins with setting I used in ssrs..

Let say in SSRS I set height = .2 , run , export in excel and have cell height =13.75
changed it = .15, run, opened under new name in Excel and still cell height =13.75

I start thinking maybe I can with pdf?

Appreciate your opinioin.
I'm SSRS 2008Rc2 and Office 2010.

Thanks
Mario
Post #1519802
Posted Thursday, December 5, 2013 10:30 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 5:52 PM
Points: 171, Visits: 6,200
My experience has been that pdf respects formatting better than Excel, particularly with narrow margins. I've had several instances where PDF will properly fit on a page but Excel wraps the last column onto a separate page when you print the report. In general I use Excel as the default export format, but if users need to print the report, I'll use pdf.

Doug
Post #1520234
Posted Thursday, December 5, 2013 3:20 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:05 AM
Points: 285, Visits: 334
Hi Mario

Incorrect margin in the exported Excel is well known issue in Reporting Services 2008, as I remember
it has been fixed in SSRS 2k8 SP2 but I didn't upgrade so I can't confirm myself, if you want to know mor about excel export limits, please read this link:http://msdn.microsoft.com/en-us/library/dd255234(v=sql.105).aspx#ExcelLimitations.

Br.
Mike
Post #1520350
Posted Thursday, December 5, 2013 10:11 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:19 AM
Points: 150, Visits: 370
Dziekuje bardzo, Veteran

M
Post #1520409
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse