I'm looking for help in adding filter to an exsisting report

[Former Member]

My current report pull the number of patients see for a particular type of cpt code, I want to add out of these 252 patients how many had an additional cpt code. Please see attached report for more details.

[abhilash_kumar · Accepted solution]

Hi Sharlene,

Could you please elaborate on " I want to add out of these 252 patients how many had an additional cpt code".

-Abhilash

[Former Member · Accepted solution]

Hello Abhilash, Yes  the patients in this query have all had a procedure between D2140-D2394, I want to know out of these patients how many also had a D1203-D1208.

[abhilash_kumar · Accepted solution]

You can use this as the formula:

.

.

and

{PatientVisitProcs.CPTCode} IN ['D2140' TO 'D2394', 'D1203' TO 'D1208']

-Abhilash

[Former Member · Accepted solution]

I tried that, but it gave me all patients that had any of the above codes.

I need only the ones that had the D2140-D2394 who also received a D1203- D1208

I also tried this but got a Boolean is required here message.

{PatientVisitProcs.CPTCode} IN [D2140 to D2394] and [D1203 to D1208]

[DellSC · Accepted solution]

This is going to be a bit trickier.  Here's what you need to do:

1.  Add a second copy of PatientVisitProcs to the tables for the report.  Crystal will show a warning that the table is already in the report and ask if you want to "Alias" it.  It will then add the table as PatientVisitProcs_1.

2.  Create a link from (I assume) your patient table to PatientVisitProcs_1.  Right-click on the link, select "Link Options" and make it a "left outer" join.

3.  DO NOT use Details sections for any data - adding the second copy of PatientVisitProcs has the potential to cause multiple records where now you only have one.  Instead, do the following:

    a.  Put all of the patient data in patient group header section(s).

    b.  If you're using data from PatientVisitProcs, put that data in possibly a CPTCode group header section.

    c.  If you're doing any counts, you'll want to use distinct counts instead.

    d.  If you're doing any sums, you'll want to use a running total instead and set it to evaluate on a formula that removes the duplicates.

4.  In the Select Expert, do the following:

{PatientVisitProcs.CPTCode} IN ['D2140' to 'D2394'] and

(

  IsNull({PatientVisitProcs_1.CPTCode}) or

  {PatientVisitProcs_1.CPTCode} in ['D1203' to 'D1208']

)

5.  To indicate that the patient also has one of the other CPT codes, you'll use a formula something like this:

if IsNull({PatientVisitProcs_1.CPTCode}) then 'No' else 'Yes'

-Dell

[Former Member · Accepted solution]

Thank you Dell, that worked perfectly.

Very Much Appreciated !!

Sharlene