Crystal Reports - Record selection by page count

[mickysavage]

Appears to be a simple task, but is proving a headache!!!

Trying to now filter my report to only select clients based on their total page count

Ideally would like to have parameter where the user could choose to have only those clients with over 6 pages returned or return only clients with 6 or less pages

Have tried various things inside Record Selection to no avail

Any help would be appreciated

Cheers

[RobDog888]

In your query (Access or SQL) you can add a field that is the
Count of each Clients number of records. Then figure out how
many records fit on a page. Not too swift, but ??? other than
doing a recordselection formula in CR with a Running Total Field.
Or suppress records that are less than 6 pages.

Check the Print State Functions in the Selection Formula Editor for
functions like PageNumer, PageNofM, TotalPageCount.

HTH