Home > Reporting Services > Landscape printing in Reporting Services

Landscape printing in Reporting Services

I always get asked about printing in Reporting Services. The 2 issues are always
1) Printing in Landscape in Reporting Services
2) After creating reports , when printed or exported to PDF you get blank pages.
Lets talk about the blank pages first. What I’ve found when authoring reports , is that when you are creating portrait reports ( reports that should either print on a normal A4 page , or be exported to a PDF file ) make sure that the report width is not more than 16 cm’s. Sometimes a report author has a table or matrix that is short enough , but still gets the extra blank page. Thats because the report width is greater than 16 cm’s. What you need to do is remove all the extra space at the right of the report. This is normally the cause of the "Extra Blank Pages" that you see when you print or export to PDF.

The above illustrates a report where the actual table is less than 16 cms but the report width is not. You will still get extra blank pages when you print this or export to PDF. Make sure therefore that there is no extra space after the table on the right ( if not needed ).

The other way to control the report width is on the Report Properties Tab.

This is a useful window, lots of properties to set here

Which brings me to the Landscape Printing option. To set your report to always print / export in Landscape mode, you need to go into the report properties box , select the Layout tab and inverse the Width and Height ie. The normal settings are 21cm for Page Width and 29.7cm for Page Height. Swop these around and you should get a Landscape Report.

The above image shows the same report exported to PDF after the change is made. Easy as pie…….

Categories: Reporting Services
  1. HemaVijay
    December 9, 2009 at 11:16 pm

    Perfect. it worked the way i wanted. Awesome explanation and illustration. Keep it up . Thanks

  2. Navster
    March 5, 2010 at 12:32 am

    Thanks alot mate, exactly what I needed for landscape formating

  3. Peter
    March 10, 2010 at 12:02 pm

    Thanks for the post. I landed here because I did something dumb trying to print in landscape. I changed the report body properties and not the report properties.In reading the post I had the epiphany: margin left + report body width + margin right = report width . If those numbers don\’t add up correctly weird stuff may happen. Pete

  4. Surya
    July 7, 2011 at 11:51 am

    Thanks…it elped us sorting out how to get report in Lanscape. Nice job.

  5. Manu
    October 4, 2011 at 2:29 pm

    Thanks !!

  6. March 16, 2012 at 7:23 am

    Perfect. Just enough information to get done what I needed.

  7. Manj
    April 10, 2013 at 9:01 am

    Its working fine thanks..Nice explanation …

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: