I have created a report (Crystal XI) and in the Details A section is where I have my fields. I have eliminated the repeating of the same authorization number, by using this formula in my Detail A Section Expert under Suppress (No Drill -Down):
not onfirstrecord and
Previous ({AUTHS.AUTHN}) like {AUTHS.AUTHN}
Another field that I am pulling is Diagnosis Code, within the Details A section as well.
I am finding that I am getting duplication on my report, because there are 3 entries in the Dx_Code table that match one authorization #. So even thought he authorization is not repeating, the one field of Dx_Code is repeating because there are multiple entried on one authorization.
Is there a way that I can tell Crystal that I only want the one authorization and only pull one row with Dx_Code data, even though there are three rows with Dx_Code data?
TIA