List Supression (for lack of a better term)

building reports crystal reports
1

Hi all,

I am working with a Health Care Db and am looking for people who have never had a certain procedure code. Here’s the scenario:

Crystal reports the person and CPTcode for each detail. Some people have 1 cpt code, meaning then only had one procedure and some have 100. I need to not report a person at all if the CPT code I am searching for matches one in the person’s list.

Very easily I can get it to supress the line if the CPT code is matched, but I need the person and their history to not appear if any code in their list matches the CPT code I am looking for. Sound like a job for an ugly subreport?

Ex:
Person A 99213
90434
90715
99215
Person B 90210
99214
90812
Person C 99120
86753
90715

Persons A and C need to go away in their entirety if I am looking for 90715. No clue how to do that one.

Thanks!

Janchenko (BOB member since 2009-10-05)

2

Hi,

Please perform the following:

  1. Create a group on CPTcode.
  2. Place the person in the detail section.
  3. Go to Report menu>> Section Expert.
  4. Select Detail section.
  5. Click X^2 button opposite to suppress.
  6. Write the following code:
    Count ({TableName.Person}, {tablename.CPTCode})>1
  7. Click Save and Close button.
  8. Click OK.
  9. Preview the report.

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)