| Janice |
|
|
Reply with quote | #1 |
I have a Crystal Report running against an Oracle database, which means I do not have the option of using stored procedures or SQL Commands.
The report has several levels of grouping.
Group 1 is the Reviewer, Group 2 the Patient Encounter, Group 3 the specific review tied to the encounter. I would like to further group the Patient Encounters by type of Insurance (Medicare vs. Other.) The only way to identify Medicare is to loop through multiple insurance details looking for a range of values in any one of those, and link that back to the encounter (Group #2).
I created a running total MCare, for "distinct EncNum", which is incremented if any of the insurance plans meet the criteria, and reset with a new encounter.
I created a formula InsType
shared stringvar InsType;
evaluateafter ({#MCare});
if {#MCare} = 1
then InsType := "MCare";
InsType
However, Crystal will not give me the option to group by InsType. I am looking for a solution to identify the account based on the details as Medicare or Other, and then use that to group and subtotal for Medicare vs. Non-Medicare accounts.
Any suggestions would be greatly appreciated.
|
| |
