sql server reporting services: I have three tables in my report. One for detailed data, and two others for
summary info. Since the detailed data table is often thousands of rows long,
I have set properties on that table to insert a page break after the table
and before the summary tables. When rendered in HTML (preview mode, and on
rpt server), I get the entire report on one page.

I set properties on the summary tables to put in a page break before each
table. these are ignored as well.

I have tried working with the page sizes, and interactive page sizes, to no
avail.

On May 30, 1:56 pm, Carl Henthorn
[quoted text, click to view]


There are only 2 things I can think of: (1) Limit the number of rows
per page. Something like this might work.
1. In the 'Layout' view of BIDS, select the table(s).
2. Right click the table and select 'Properties.'
3. On the 'Groups' tab, select the 'Add...' button.
4. Below 'Group on:' and 'Expression' enter the following:
'=Ceiling(RowNumber(Nothing)/18)'
5. Select 'Page break at end'
5. Select 'OK' and 'OK' again.

[NOTE: The format in step 4 is: =Ceiling(RowNumber(Nothing)/
NumberOfRowsPerColumn) ]
(2) Also, you might try including a subreport for the different table
controls, normally this will force page breaks. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant