MS SQL Reporting Services - exporting RDL file to PDF format - Orientation problem

Posted on 2005-04-18
Last Modified: 2008-01-09
  I have a report which is correctly displayed in Landscape orientation on screen as well as prints properly but when I export this to PDF format, it breaks into two pages as PDF file?
 What might be the reason and what settings need to be done to fix this issue?

Question by:Rahool
    LVL 14

    Accepted Solution

    In report designer goto the Properties of the report, and select the layout tab.  Ensure your page width and height are set to 29.7cm and 21cm (assuming A4 is what your using).  Take note of your left and right margins.

    Select the Body of the report and goto Properties.  Ensure that the Size -> Width + your left right margin sizes is less than or equal to 29.7cm.

    Repeat for the Page Height if the report 'overspill' is down and not across.

    If these are OK, you might want to look at the Properties of your table/matrix cells under Layout -> CanGrow.  If this is set to True, then the cell will grow in height if the data doesn't fit.

    Author Comment

    It didn't work, I checked and implemented all settings as suggested by u.
    It seems i've to revisit Subreports. This Report conatins 3 sub-reports.
    LVL 7

    Assisted Solution

    Assuming your report is for 8.5 x 11 inch paper, your report width would be 11 in and report height is 8.5 in

    Then let's assume you have left, right, top and bottom margins of .5 inch

    So, your usable report area is now 7.5 in x 10 in

    Here is the key to the problem you are having:

    Your BODY element in your report cannot exceed or even equal the usable report area width.  Based on the example above, I would set the BODY width to 7.25 in.

    You should also not have any report objects touching the edge of the BODY, so if you have a table for example, it's width would be something like 7.15 in.  

    Again, report sets the page dimensions
    Body should be Report width minus total margin width minus a buffer of .125 or so
    Tables and all report objects should not touch the edge of the BODY element.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Hi, In my previous Article  ( discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
    How to increase the row limit in Jasper Server.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now