Extract only certain procedure names from a table

[JonathanNYC]

Is there a way to establish a group (not sure if that is the appropriate term) for only certain items that appear in a table, so that I may be able to use that group in my record selection criteria.

I have a table with 1000 different procedure names in it. Each procedure name has a corresponding 3 or 4 digit resource number associated with it. I need to report on primary hip replacement cases only. The procedure names vary and do not always contain the words “Replacement Total Hip”. I could do an “is like” on the procedure names but there is much variability among the names.

Here is an example of replacement hip names in our system:

Replacement Total Hip, Biomet 1759 (Resource Number)
Replacement Tot Hip, Osteonics 3145
Resurfacing Total Hip, Wright 1631
etc.

Again, I wish to establish a group or formula that includes the applicable resource numbers and then use the group in my record selection statement.

I am using Crystal Reports 10 and a database from Mediware that is part of an OR Operating Room Scheduling and Documentation system.

 

[MCuthill]

Jonathan,

I think that synapsevampire & lbass have advised against this before (as it can lead to items being included in any group) but I am not sure. At any rate, this is how I handle such a scenario.

Create a formula field and populate it with the following, and group on this Formula Field... (@Surgery_Type} in my examples.

[blue]IF[/blue] {table.resourcenumber} [blue]IN[/blue] [1759,3145,1631,..etc] [blue]THEN[/blue] "Hip Surgery" [blue]ELSE[/blue] "Other"

Note: You can then use this formula to identify other surgery types you may wish to differentiate.

In your record selection you can either add:

{table.resourcenumber} [blue]IN[/blue] [1759,3145,1631,..etc]

OR

{@Surgery_Type}="Hip Surgery"

Hope this helps,


Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[JonathanNYC]

Many thanks Mike, I incorporated your tip. Most appreciated.

 

[synapsevampire]

Mike: The secondary OR part of the record selection will nt be passed to the database.

If you use the following in a record selection:

table.resourcenumber} IN [1759,3145,1631]

Then it will return only those that are hip replacements, so your formula will do nothing but the hip replacements.

If they simply want the hip replacements ganged together in a group, then your formula is fine and I doubt that anyone has complained about this:

c

But don't filter in the record selection, unless you DON'T want any otehrs, in which case the formula could have been:

if table.resourcenumber} IN [1759,3145,1631,..etc] then
"Hip"
else
"Could never happen..."

-k