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.
| Author |
Topic |
|
urpalshu
Starting Member
21 Posts |
 Posted - 2006-10-05 : 17:44:05
|
| In some reports, you may want to place a page break at the end of a specified number of rows instead of, or in addition to, on groups or report items. To do this, create a group in a data region (typically a group immediately outside the detail), add a page break to the group, and then add a group expression to group by a specified number of rows. The following expression, when placed in the group expression, assigns a number to each set of 25 rows. When a page break is defined for the group, this expression results in a page break every 25 rows. =Int((RowNumber(Nothing)-1)/25)Question?I have two tables in my report. If I specify page breaks on both the tables seperately I won't be able to see both the tables in one page.I have a page break set on each table with a Group Item.I can view one table at a time. I need to view both these tables at the same time on one page.Please help with exact steps for the solution if possible.Thank you, |
|
|
|
|
|
page break at the end of a specified Groups