Omitting Blank Pages

[Linda_M_(Guest)]

I have a report that is calculating the Gross profit on each order by salesperson. I want my report to print only those records that meet the criteria I have set up - which is all records with a total GP <= 20%. This works fine. However when viewing the print out it is also printing the blank header sheets for each salesperson who does not meet the criteria. I don^t want to print these pages as they are blank except for the header information. I have already set the Format Option to compress Record/Group Lines and I need to see the detail so I can^t select Suppress Record Lines.____Also, I want to have the page numbers at the bottom of my report so I know how many pages my report is in total. But right now it keeps printing Page 1 on each page. I know there is a way to do this but for the life of me can^t figure out how.____Thanks for any help,____Linda

[John_Pasternack_(Guest)]

Are you forcing a page break for each salesperson? If so, maybe you just need to suppress the page break line from printing as well.

[kfleming]

Hi John,____Thank you for your reply. The report is set up to reset for each group. I^m not sure how to force it to suppress a page break. I thought suppressing Record/Group lines was supposed to omit blank records.____As far as the ReportPage() - this worked like a charm. Thank You Kathleen.

[Linda_M_(Guest)]

If you have the Reset Page box checked in your group field, then each new group will start page numbering at 1.__If you are using V9 or above you can use the REPORTPAGE() function instead of the PAGENO() function to print a page number that does not reset at each group.____Kathleen__R&R Support