Duplicate Help

[metalteck]

I'm currently have a report that lists all patients from 2 different units, units #7 and #11. The patients can have appointments in one of these units or in both. Right now when I generate the report, I get all patients, whether they only have one appointment or 2. I want to be able to only get those patients that have both appointments in unit #7 and #11 and excluding everyone else.

I am currently using Crystal 8.5 and the database is SQL Server.

I appreciate any help anyone can give me.

Here is my code.

{appt.start_datetime} in {?StartDate} to {?StopDate} and
and {resunit.resunit_id} in [11, 7]

 

[lbass]

Use your current record selection formula. Insert a group on {table.patientID} and create two formulas:

//{@11}:
if {resunit.resunit_id} = 11 then 1

//{@7}:
if {resunit.resunit_id} = 7 then 1

Then go to report->selection formula->GROUP and enter:

sum({@11},{table.patientID}) > 0 and
sum({@7},{table.patientID}) > 0

If you need to summarize across patients, then you will have to use running totals, as non-group selected records would still contribute to inserted summaries.

-LB