locked
How to Fit all the Columns in one Page RRS feed

  • Question

  • Hi All,

    I was developed a Report using Report Builder 3.0, I can able to export my report into PDF & Excel. Here when I export it into PDF, all columns have been fitted in a single page. But when I export it to Excel and see the print preview/page layout, there some of columns went to next page. Is there anything we can do for both?. Is there any configuration files we have? or can we override the "Shrink To Fit Printout" option in Excel.

    Regards,

    Sarav


    Regards, Sarav Raj!

    Friday, September 20, 2013 10:29 AM

Answers

  • Hi All,

    I was developed a Report using Report Builder 3.0, I can able to export my report into PDF & Excel. Here when I export it into PDF, all columns have been fitted in a single page. But when I export it to Excel and see the print preview/page layout, there some of columns went to next page. Is there anything we can do for both?. Is there any configuration files we have? or can we override the "Shrink To Fit Printout" option in Excel.

    Regards,

    Sarav


    Regards, Sarav Raj!

    Hi Sarav,

    Thanks for your post.

    I don't think this issue is more related to SQL Server Reporting Services. Generally, if we print preview a wooksheet which include a lot of columns, Excel will automatic split into several pages to display those columns. This behavior is by desing in Excel.

    So, if we want to display all columns on one page, we can directly use "Fit all columns on one page" functionality in Excel print setting. For detail steps, please see:
    Fit All Excel Columns on One Printed Page: http://www.youtube.com/watch?v=3acCOfTd4wE

    In addition, we discuss SQL Server Analysis Services related issue in this forum. If you have any more question regarding SQL Server Reporting Services, please post them in the following forum:
    https://social.technet.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices

    Best Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Monday, September 30, 2013 12:30 AM
    Monday, September 23, 2013 8:01 AM

All replies

  • There is a good discussion of this, here - http://social.msdn.microsoft.com/Forums/sqlserver/en-US/64c99005-0bb7-4257-9f67-b5dafe5d52c3/export-print-formatting-from-ssrs-to-excel

    The summary is that PDF is the best method for exporting and printing.  Excel is best for viewing and manipulating the data on export, but not for holding print settings.

    Cheers,


    Martina White

    Monday, September 23, 2013 12:27 AM
  • Hi All,

    I was developed a Report using Report Builder 3.0, I can able to export my report into PDF & Excel. Here when I export it into PDF, all columns have been fitted in a single page. But when I export it to Excel and see the print preview/page layout, there some of columns went to next page. Is there anything we can do for both?. Is there any configuration files we have? or can we override the "Shrink To Fit Printout" option in Excel.

    Regards,

    Sarav


    Regards, Sarav Raj!

    Hi Sarav,

    Thanks for your post.

    I don't think this issue is more related to SQL Server Reporting Services. Generally, if we print preview a wooksheet which include a lot of columns, Excel will automatic split into several pages to display those columns. This behavior is by desing in Excel.

    So, if we want to display all columns on one page, we can directly use "Fit all columns on one page" functionality in Excel print setting. For detail steps, please see:
    Fit All Excel Columns on One Printed Page: http://www.youtube.com/watch?v=3acCOfTd4wE

    In addition, we discuss SQL Server Analysis Services related issue in this forum. If you have any more question regarding SQL Server Reporting Services, please post them in the following forum:
    https://social.technet.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices

    Best Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Monday, September 30, 2013 12:30 AM
    Monday, September 23, 2013 8:01 AM