We are facing some problem while exporting the SSRS (SQL Server 2005 SP2 installed on win2K3) Report to PDF format, problem is when we export report to PDF format all the data after 80 columns gets wrapped to next page which not only increases no. of pages in the reports but also disturbs the report format for example if a report contains only one page and 320 columns of data and if we export it to PDF format then the PDF file will have 4 pages each having 80 columns of date. Has anybody faced the similar issues? would appreciate if you can give solution for this problem or forward any link which discusses the same.
That is a common problem, you are exceeding the width of a sheet of A4. With 80 columns your column width would have to be tiny to fit them all on one page. You can get yourself a little extra width on the page by having it render in landscape mode, just swap over the width/height values under the PageSize parameter for the report. You can also reduce the margin sizes. These techniques will not get you a lot of extra space, if you still need more then the only way to get it is to redesign the report (more tables) or select less data (narrow the parameters or filter the returned data).
sql
No comments:
Post a Comment