Can I limit 'detail' rows per page?

Is there a way from the report designer, in layout mode, to set a limit
of rows to, let's say 5 per page?
Thanks,
TrintHello, I would like to do the same thing. For example, I would like to create an invoice template and have a header section contain the Billto, Shipto addresses and a footer section contain the remittance section. However, the middle of the 'page' should have a fixed number of records for the detail items on the invoice. If more than the fixed amount of detail records is reached, a second page would be displayed. Any help or insight with this would be helpful. Thanks, Dave
--
Message posted via http://www.sqlmonster.com|||Add a group to your table, set the group expression to
=System.Math.Floor((RowNumber(Nothing)-1)/<# of rows you want to display in
a page>, and turn on page break on the group. The header and footer sections
would be the group header and footer, and you can mark them repeated on new
page.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave C via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c5d891b35fa44feeaef5957179524cdc@.SQLMonster.com...
> Hello, I would like to do the same thing. For example, I would like to
create an invoice template and have a header section contain the Billto,
Shipto addresses and a footer section contain the remittance section.
However, the middle of the 'page' should have a fixed number of records for
the detail items on the invoice. If more than the fixed amount of detail
records is reached, a second page would be displayed. Any help or insight
with this would be helpful. Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com