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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

First 50 records 1

Status
Not open for further replies.

lous

Technical User
Joined
Mar 8, 2002
Messages
53
Location
US
I have a report that I'd like to print out just the first 50 records after going through the entire database and totaling things up.

Any idea how to do that?

Thanks.
 
For Crystal 8.5, you could do a count on each detail line, and supress once it reaches 50. (Right-click on Details, [Format Section] and the formula box for suppress.
Madawc Williams
East Anglia
Great Britain
 
You can also use a group selection formula -

RecordNumber <= 50

As Group Selection is done after the summaries, your totals will include all the records you have selected. Editor and Publisher of Crystal Clear
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top