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
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Number of pages in a report

Author  Topic 

harlingtonthewizard
Constraint Violating Yak Guru

352 Posts

Posted - 2009-02-16 : 20:10:55
1. I have two reports that are the same with one exception. One has the group rows expanded by default while the other has them collapsed. When I run these reports they are both 30 pages long. I expect the expand report to be 30 pages but the collapsed a few pages. Why does it use the same number of pages in collapsed mode? I have turned off all of these features for the table with no change:
Insert a page break before this table.
Insert a page break after this table.
Fit table on one page if possible.
Repeat header rows on each page.
Repeat footer rows on each page.
Header should remain visible while scrolling.

2. I have a second problem where the reports when run from report manager some are displayed as one very long page while others appear with many pages, all are long reports. All have the layout properties set to page width 29.7cm and page height 21cm with 1cm margins, A4 landscape page size.

harlingtonthewizard
Constraint Violating Yak Guru

352 Posts

Posted - 2009-02-18 : 22:27:32
Any ideas, after playing with all the parameters I can think I still cannot figure this one out? When it decides to create a new page in report manager? The obvious ones are page break.
Go to Top of Page
   

- Advertisement -