Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 SSRS 2005 page size issue

Author  Topic 

markus76
Starting Member

2 Posts

Posted - 2009-09-17 : 16:51:32
SSRS 2005 :

In the browser , report returns all on one page
( the pagination control says page 1 of 1 )

but in export to PDF , it shows correctly as 30 pages .

How do I make the correct number of pages show in the
browser ? Is this a bug ? I already set Interactive Height
and Width to be the same as the Page Height and Width .

mmattson
Starting Member

3 Posts

Posted - 2009-09-23 : 14:59:54
Click on the Print Preview Icon. However, for some rendering, this will show black areas.
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-09-24 : 10:07:44
The Interactive size detmines how many records per page in Report Viewer HTML. PageSize is used to send to PDF rendering BUT also takes into account the Margin size data.

John
Go to Top of Page

markus76
Starting Member

2 Posts

Posted - 2009-10-02 : 11:07:32
I learned that this is a bug in 2005 related to conditionally visible table rows .
If I have a row that is conditionally visible , this problem occurs ( everything on one browser page ) .

Still , I have some reports that don't have conditionally visible table rows and I still
have incorrect pagination ( browser has 20 pages , pdf and print preview has 30 pages ) .
I tried manipulating the Interactive size but doesn't help ; different page numbers happen but
still browser and pdf not the same .

JCirocco , from what you are saying , Interactive Height should be Page Height minus margins
but it doesn't seem to help . I also set the report body + page header + page footer = Page Height .
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-02 : 13:20:19
markus, not quite that simple. We initially tried to get them to match and gave up. We make sure we have "Header should remain visible when scrolling" checked and users don't complain (well the DO but not about this now...)

John
Go to Top of Page
   

- Advertisement -