displaying cases that only meet specific criteria

[GnoXimian]

I have a situation where I need to select only certain medical procedures based on procedure name, however, there may be more than one procedure name selected for a case.

Here is an example:

ProcID Patient Procedure
1 Doe,John Dx Neuro
Int Neuro

2 Green,Bob Dx Neuro

3 Black,John Dx Neuro
Int PV

In the three cases above all procedures have a Dx Neuro involved with them. However, I do not want to distinctcount the ones that have an Int procedure involved as well, only cases that do not have an Int procedure, i.e. Bob Green's case.

When I perform a not({field}) like "Int*" it only clears that specific procedure name, however, it still counts the procedure.

I am trying to find a way that I can count only the one that have a Dx Neuro procedure without any Int Neuro procedures.

Data is grouped by Case Type (either Int or Dx) and by Physician Name.

Any help would be greatly appreciated.

-Gnox

 

[CoSpringsGuy]

create a formula like this

if {field} = "Dx Neuro" then 1 else 0

Put that in the deatails section of your report. Right click it and do a count (or distinct count) summary to the group level you want. Then you can delete that formula from the detail section.

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

Do all doctors have a Dx Neuro record?

if so, then you only need to check for the presence of Int. I would create a formula like this:

//{@hasInt}:
if {table.procedure} like "Int*" then 1

Then go to report->selection formula->GROUP and enter:

sum({@hasInt},{table.dr}) = 0

If you need to also check for Dx Neuro, create a separate formula like the Int formula for that, and then change the group selection to:

sum({@hasDx},{table.dr}) > 0 and
sum({@hasInt},{table.dr}) = 0

-LB

 

[GnoXimian]

Thanks guys!

The procedure name for the case isn't really a part of the physician record, but a part of the case record, the physicians name is associated with that case.

Counting Int Neuro procedures is easy, I just distinctcount all PROCID's that have a procedure like Int Neuro.

In this situation, all cases have a Dx Neuro procedure, whether it is a Dx Neuro procedure alone, or with a Int Neuro.

My issue is that I need to count cases that only have a Dx Neuro present, without an Int Neuro. (This is because a Dx Neuro can be done first then the doctor determines, based on the Dx Neuro findings, if a Int Neuro is neccessary.)

I want to group by Dx Neuro/Int Neuro and then a sub group of physicians.

I think you're both on the right track, you obviously have more experience with this than I do, which I am grateful for. I'm trying using your examples, but I am not having much luck.

-Gnox

 

[lbass]

I'm sorry, I thought the names were doctors, not patients. So the group should be on the patient case.

If the issue is just the counting, then insert a running total that does a distinctcount of patient case, evaluate using a formula:

sum({@hasInt},{table.patientcase}) = 0

Reset never (if at the grand total level).

This requires a group on case though. I am unclear on what you want the final display to be. You mention a group by

Dx Neuro/Int Neuro

--what does that mean? What would the resulting report look like?

-LB