Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how can i restrict the number of records in a page

Status
Not open for further replies.

jessy111

Technical User
Nov 17, 2002
22
IN
Hi,

i am using a subreport in the main report and main report is grouped by a field machine name.Based on the machine name group subreport is printing the required data.That works fine.
NOw my issue is i need to print only one record in one page.That is one page should contain only one machine record in the main report and the corresponding subreport of the same machine name.

Pls help

Jessy
 
Here is the method I used:

Insert a section below the section that contains the sub-report (mine is in the details band). Then, conditionally format the new band for a "New Page After" (x-2) using:

onfirstrecord or
recordnumber=pagenumber and not onlastrecord

Mike

Before: After
[morning] [bugeyed]
 
Using a similar approach to the last post but a differnet formula:

Remainder(Recordnumber,10)=0

will force the page break when the record numberis perfectly divisible by 10. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Hi mike & dgillz,

both methords works thanks a lot

Jessy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top