Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2439
  • Last Modified:

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

  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?

2 Solutions
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.
RahoolAuthor Commented:
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.
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now