suppress duplicate records

[lindagoodwin]

I have a report with patients that have been in the hospital within a date range.
The report contains the following tables:

VISIT.ADMIT_ARRIVE_DATE
VISIT.DISCHARGE_DISPOSITION_DATE
PATIENT.NAME
REG_DATED_ROOM.CODE
VISIT.PATIENT_ACCOUNT_NUMBER

The report works great with the exception of:

If the patient has been moved to a different room in the time of stay I will get a record for each room the patient has stayed in.

I only want to see the record once with the Reg_Dated_Room. Code on the Visit.discharge_disposition_date. In other words, I want to see one entry per stay with the room on the day of discharge.

The patient will have the same VISIT.PATIENT_ACCOUNT_NUMBER through out the stay.
I've tried suppressing in the section detail if the VISIT.PATIENT_ACCOUNT_NUMBER = previous (VISIT.PATIENT_ACCOUNT_NUMBER)
but that is not working either.

Please Help!

 

[AdventurGurl]

Group the report by VISIT.PATIENT_ACCOUNT_NUMBER and then copy all of the information to display in the group footer section also. Suppress the details section all together. Highlight the REG_DATED_ROOM.CODE, right click and select Insert --> Running Total. Use Maximum type of summary, evaluate for each record, and reset on group ..ACOUNT_NUM.

I'm sure there is an easier way, but that should work. Let me know if you have any questions.
-Carrie

 

[Madawc]

If that doesn't work, try re-adding VISIT as an alias, linked via VISIT.PATIENT_ACCOUNT_NUMBER. The alias will function like a separate table: you will need to group on it and suppress details, show data in group header.

When there are two records on the alias table, suppress the group if it the "second instance", whatever method you use. Could be a start date after the 'minimum start date" for the group.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lindagoodwin]

AdventurGurl that worked perfectly. I am very new at using Crystal and I was amazed how that worked! I would have never thought of the group footer. I'll remember that for the next time. Thanks so much