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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field not printing on 1st record when removing dups.

Status
Not open for further replies.

EricRN

Technical User
Jul 13, 2001
13
US
I am fixing an existing report, using Crystal 8.5, that prints out a surgery schedule. There are times that a patient has multiple procedures. In these cases, we don't want the patient's name, surgery time, and DOB to repeated for each procedure. For each of these, the suppress if duplicated works. However, the patient type (listed as IN, OP, AM) cannot be suppressed in this way since we have many OP patients and may list in a row. I tried to put the following formula into the suppress X2 box:

{patient.name} = previous({patient.name})

This works well, except the field won't print on the first record of the report. The line that lists information is in the details section of the report. How can I fix it so it prints on the first record and then follow the formula?

Thanks for your help.

Eric Hendelman
 
Hi EricRN,

Try this for the suppression formula:
Not(OnFirstRecord) and {patient name}=previous{patient name}

lb
 
Thanks, you Guys. Unfortunately, the way the canned report is put together, made for some interesting resorting and grouping when I tried to add the patient name group. However LB's suggestion seemed to do the trick. I appreciate your responses!

Eric
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top