Page Breaks -- sql server reporting services

ERS Developer
4/20/2006 3:50:02 PM

Hi,
I am using RS 2000. and have a problem with the Page break.
I have header and footer in my report and a 2Tables in the Body part.
If the number of rows in the table1 exceeds some records(say 100) the page
is printed in 3 sheets.
FristPage :with Header and footer and Table1 75 Records.
Second Page: with out Header and footer and reaming 25 records of table1
Third page: with Header and footer and table2 data.

What i am looking for is 2 pages.
FristPage :with Header and footer and Table1 75 Records.
Second Page: with Header and footer ,Reamaing 25 records of table1
and table2 data.

What to be done to achive this?

/
S

Amarnath
4/21/2006 12:44:01 AM

You can use groups and the expression is

=Int((RowNumber(Nothing)-1)/25) instead of 25 you can have 75. In this e.g.
page breaks every 25 pages.

Amarnath

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Page Breaks