Hi, i had a problem in report rendering in to PDF format ..... like

Question

Post reply

Hi, i had a problem in report rendering in to PDF format ..... like

pavan.sunkara

SSC-Addicted

Points: 471
More actions
October 23, 2007 at 11:41 pm

#176590

If there are six columns in report preview and when i render this to PDF as per client specification only first three columns are seen in first page of the PDF and the remaining three columns are seen on second page of PDF... so how to get out from this...

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

okhere SSC-Addicted Points: 443 More actions · Answer 1

Hi,

I guess the solution would be to export it to Landscape instead of Portrait.

Here is a link on how it's done:

http://forums.devarticles.com/microsoft-sql-server-5/reporting-services-export-pdf-in-landscape-9209.html

I hope that helps,

Osama

pavan.sunkara SSC-Addicted Points: 471 More actions · Answer 2

Hi Osama,

Thanks a lot for ur reply, and still can u clarify more on this..... before posting this i even tried with Lanscape too....

as i said three columns are going to secong page of PDF, if i use land scape still one column is going to secong page of PDF, as we are working on ERP we include more columns in report......

Kindly provide solution

Thanking you

With Regards

pavan.sunkara:)

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 3

The trick is to set the page width (under Report Properties and Layout) to a setting that fits that actual report's width and NOT to the actual PAPER's width.

So if your report in the designer is 18", set the width to 18" + your margins even if you're printing on 8 1/2 x 11".

I've had to do this several times with PDF's and once you get the setting right, the export process will auto-scale your report to fit.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 4

This might be the problem with your printer / fax to which you connect the system for exporting the data.

Hence, try to find the paper size of the element and adjust the settings of your report.

Clear the un-wanted space/lines of the report column-by-column so that the size of the main design gets reduced so that the chances of your values will not get into next page but will certainly be available within the specified columns.

pavan.sunkara SSC-Addicted Points: 471 More actions · Answer 5

Thankq Jason Selburg...... its working when i changed the width in Report Properties:)