Reporting Services - Export to PDF

Hi all,

I have designed report in SQL Server reporting services.
The report works well and I can call it from ASP.NET application by passing parameters in the URL.

The report looks fine in HTML view. However, when I export it to PDF, the report does not fit on the page.
The width of the page is not enought to hold all the columns.

My report has lot of columns. So I want to print it in Landscape mode. For this, I changed page width to 11
and height to 8.5 in. But still all the columns do not fit on the page.

Not able to figure out what exactly is the problem.
Do I need to change page width/height using DeviceInfo and specify it in the URL along with other
parameters?

Thanks in advance

Vikram

Did you find the solution to this?

I am having the same issuse and would appreciate any help on this.
Thanks,
aruna

I've been working with reporting services quite a bit recently and have hit this problem a lot.

My first suggestion is to get rid of the page margins. They are defaulting to 1" on each side. You will find this in the Report Menu under Report Properties.

Another thing to make note of is the rulers on the design page. Even though you may have widened your page to 11", it might still be only using 8.5". If this is the case, your solution lies in the Layout tab of the report properties.

If there are too many columns and you are desperate to keep your report on a regular sized page, you can always decrease the padding in each cell of your report. Currently its 2pt all around the cell.


Hope this helps