Printable View
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
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