Finding Only 1

[Charliy]

Crystal 11

My data looks like this:

PATID: 300 EPISODE: 3 GUAR_ORDER: 1 GUAR_ID: 103
PATID: 300 EPISODE: 3 GUAR_ORDER: 2 GUAR_ID: 1101

PATID: 401 EPISODE: 5 GUAR_ORDER: 1 GUAR_ID: 103

PATID: 455 EPISODE: 2 GUAR_ORDER: 1 GUAR_ID: 32
PATID: 455 EPISODE: 2 GUAR_ORDER: 2 GUAR_ID: 103

I need to select the records where Guarantor 103 is the only Guarantor - so in this example I only want PATID 401.

Any ideas?

 

[briangriffin]

Insert a count of guarantor in the Patient group footer. Then use the group selection expert to limit it to those patients with a guarantor count of 1.

Then in the record selection expert, restrict it to guarantor 103 only.

Keep in mind that group selection is really just hiding the unwanted groups, so any totals you have may be incorrect. You would have to create formulas to return the correct totals.

 

[Charliy]

Ah, the formula I would need would be shared variables, which actually solves my entire problem! Thanks Brian.