I am very new to Crystal, so bear with me a little
I have a patient billing report that has One Patients procedure pr page (All patient information is spread around on one detail page, demographics, insurances, Clinical data etc) So lets say a patient has two insurances, a primary and a secondary. What is happening is that I get two records (pages) in this instance, when I really need both primary and secondary insurance on the one page. Any way this can be done?
Try using two copies of the table that has the insurance information - one that is filtered to select the primary insurance an the other is filtered for the secondary.
In the Database Expert when you try to add a table that is already in the report, Crystal will let you know it’s already there and then ask if you want to “alias” it. At that point the table will be added to the report with a suffix of “_1”. So, if your table name is “Insurance” you’ll have Insurance and Insurance_1 in your report. Once it is added, create a Left Outer join to Insurance_1.
You then need to tweak the selection criteria. In the Select Expert, manually edit the formula. I’m going to assume you have a field called “Primary” that is 1 if the record is for primary insurance and 0 if it is secondary. Assuming that the patient may not have any insurance, you’ll add something like the following to the formula:
(IsNull({Insurance.PatientID}) or {Insurance.Primary} = 1) and
(IsNull({Insurance_1.PatiendID}) or {Insurance_1.Primary} = 0)
Of course you’ll need to modify this to work with the actual tables and fields that you have, but this should get you close to what you’re looking for.
(BOB member since 2007-04-16)