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 we get total no. of records printed

Status
Not open for further replies.

ZABARVAN

IS-IT--Management
May 24, 2003
186
SA
Hi.

I want to know the total no. of records printed in a multi table report and Is there any function to know the number of lines printed on a page.

Thanks for the help.

Zab
 
For a report where you might be using group selection or suppression, use a running total that counts a recurring record. If any records are suppressed, you would have to use the opposite of the suppression criteria in the evaluation section of the running total.

For a page count, you can create a manual running total, by placing a reset formula in the page header:

whileprintingrecords;
numbervar pgcnt := 0;

And in the detail section (or other sections if you want to count them also, add:

whileprintingrecords;
numbervar pgcnt := pgcnt + 1;

You can display the result in the page footer if you like:

whileprintingrecords;
numbervar pgcnt;

-LB
 
HI
Thanks for your tip, I will try it. Thank you very much.

Zab
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top