Issue:

Need to pull patients that only have a Primary Insurance.

Patient-------------Primary Insurance
           -------------Secondary Insurance
           -------------Tertiary Insurance

Somehow I need to have the report scan through the insurance table and if it finds a primary insurance, pull the record. If if findsa  primary and a Secondary, don't pull the record.

Obviously, it the patient does not have a Secondary, it won't have a tertiary either.

All my data is placed in a group footer (a patient / record pr. line, because I am only summarizing. (Patient total charges, patient total payment etc)

I need to select only on primary insurance in report selection. Pri / Sec / Ter Insurances have rank numbers, so I know what rank number to select on.

I suspect I somehow need to use a variable to do this but unsure as to how I would set this up.

Appreciate any insight.

 


Edited by TorLang - 06 Jun 2013 at 5:26am

That works, but it looks like the record is still there, just with a blank secondary and tertiary insurance. I don't need to select those records at all (with sec. or tert. insurance)

A group select..

Yep, moving my data to the detail line shows one record pr. insurance. If the patient have 3 insurances, I see 3 lines of records.

Correct. Instead of the rank number, I am using the insurance name. But yes, you are correct. (We're talking records on detail line now)