Count and note missing records in a sequence...

[broadwar]

Per client number and date, I am expecting for ex. a nursing assessment to have 4 pages. Each page creates a record on my report. I need to count those records in that group, and I need the report to tell me which pages I have not accounted for.
Ex.
Client Date Document
4 5/3/2002 50013013
4 5/3/2002 50013014
4 5/3/2002 50013016
Group 4 5/3/2002 missing PG 3

I can indicate which documents belong in the set, and which number = which page.

 

[IdoMillet]

You can use a variable to achieve this.

It is not clear what is the logic that would let you know if page 1 or page 2 is missing.

hth,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com