none
Export print formatting from SSRS to Excel?

    Question

  • Hello,

    Is there a way to export page settings in my SSRS reports to excel?  My customers would like to be able to print my exported report on a 11 x 17 sheet of paper in landscape orientation.  They would also like it scaled to fit one page.  When I export, my excel file automatically goes back to portrait orientation on a standard sized peice of paper with no scaling. 

    Any help would be greatly appreciated!

    • Moved by Eileen Zhao Monday, June 18, 2012 9:02 AM (From:SQL Server Integration Services)
    Friday, June 15, 2012 4:37 PM

Answers

  • Hi Rduffy2530,

    From your description, it seems that you set the size of your report to fit the paper size, and you export it to excel, but there is no scaling happened on the report, right?

    When we export a report to excel, the Excel rendering extension uses the page height and width settings to determine what paper setting to define in the Excel worksheet. Excel tries to match the Page-Height and Page-Width property settings to one of the most common paper sizes. And orientation is set to Portrait if the page width is less than the page height; otherwise, orientation is set to Landscape. Just as Mike Davis said, Excel is good for manipulating the data after exporting the report. Other format rendering is better for printing.

    So in your scenario, you can export your report to PDF format, and then print the exported report on an 11 x 17 sheet of paper in landscape orientation. For more information about excel rendering, please see:
    http://msdn.microsoft.com/en-us/library/dd255234(v=sql.105).aspx

    Regards,
    Charlie Liao

    • Marked as answer by Eileen Zhao Friday, June 29, 2012 1:18 AM
    Tuesday, June 19, 2012 8:55 AM

All replies

  • This needs to be on the SSRS forum.

    But to answer your question, No. The export to excel is basically a data dump with a little bit of formatting to make it look like the report. But the printing settings are not something exported from SSRS. PDF is better for printing.Excel is good for manipulating the data after exporting the report.



    Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

    Friday, June 15, 2012 5:45 PM
  • Hi Rduffy2530,

    From your description, it seems that you set the size of your report to fit the paper size, and you export it to excel, but there is no scaling happened on the report, right?

    When we export a report to excel, the Excel rendering extension uses the page height and width settings to determine what paper setting to define in the Excel worksheet. Excel tries to match the Page-Height and Page-Width property settings to one of the most common paper sizes. And orientation is set to Portrait if the page width is less than the page height; otherwise, orientation is set to Landscape. Just as Mike Davis said, Excel is good for manipulating the data after exporting the report. Other format rendering is better for printing.

    So in your scenario, you can export your report to PDF format, and then print the exported report on an 11 x 17 sheet of paper in landscape orientation. For more information about excel rendering, please see:
    http://msdn.microsoft.com/en-us/library/dd255234(v=sql.105).aspx

    Regards,
    Charlie Liao

    • Marked as answer by Eileen Zhao Friday, June 29, 2012 1:18 AM
    Tuesday, June 19, 2012 8:55 AM