arrays in group / Problem with grouping

[lareya]

I have a question regarding groups.

Currently I have two groups
group one is a use a formula for a group name:

IF {POST_CASE.MAIN_PROCEDURE_ID} IN ["092200", "092205", "092300", "096853"]
THEN
"ASSORTED COLON CASES"
ELSE
IF {POST_CASE.MAIN_PROCEDURE_ID} = "085400" THEN
"TOTAL KNEE ARTHROPLASTY" ELSE
IF {POST_CASE.MAIN_PROCEDURE_ID} = "085300" THEN
"TOTAL HIP ARTHROPLASTY" ELSE

2nd group:

Post_Case.Provider_Short_Name

So my procedures look like this:

Total Hip Arthroplasty
Dr. X
Dr.y
Total Knee Arthroplasty
Dr. x
Dr.y

Which is perfect. But for the procedures that I had in a array it looks like this.

ASSORTED COLON CASES
Dr. X
Dr. Y
ASSORTED COLON CASES
Dr. X
Dr. Y
ASSORTED COLON CASES
Dr. X
Dr. Y
Dr. z


Now is there a way that I can show "all the ASSORTED COLON CASES" in one group like the others?

ASSORTED COLON CASES
Dr. x
Dr. Y
Dr. z
Thanks alot!

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Crystal 8.5; ORSOS/One Call Hospital Scheduling System v9.3; SQL database; Huge Newbie to Crystal! Operating Room RN Analyst

 

[BoniR]

hello!
try:

IF {POST_CASE.MAIN_PROCEDURE_ID} = "085400"  THEN
"TOTAL KNEE ARTHROPLASTY" ELSE
IF {POST_CASE.MAIN_PROCEDURE_ID} = "085300"  THEN
"TOTAL HIP ARTHROPLASTY"  ELSE
"ASSORTED COLON CASES"

hth,
B~

Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269

 

[lbass]

The problem is that you grouped on the field, but only used your formula for the group name. You need to instead insert the group on your original formula.

-LB

 

[lareya]

Okay,
Bonir: I tried that & I still got the same results
ASSORTED COLON CASES
Dr. X
Dr. Y
ASSORTED COLON CASES
Dr. X
Dr. Y
ASSORTED COLON CASES
Dr. X
Dr. Y
Dr. z

and I think I will soon have to add other procedure ID's that are similiar to the same group for other type cases like the assorted colon cases.


lbass:
I am unsure what you mean. I have in my marbles selection all the listed procedure ID's e.g.:
Is one of: {POST_CASE.MAIN_PROCEDURE_ID}
092200
092205 these are procedure ID's I sort out to get the
092300 types of cases I need.
096853
etc.,

When I try to put the formula I have for the groups it gives me an error about needing to be bolean

TIA
Lareya

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Crystal 8.5; ORSOS/One Call Hospital Scheduling System v9.3; SQL database; Huge Newbie to Crystal! Operating Room RN Analyst

 

[lbass]

Copy and then remove your formula from the customize group name area and then paste it into a new formula (go to the field explorer->formula->new). Then go to insert->group and choose your formula as the field to group on.

-LB

 

[lareya]

Thank you Lbass!!

That worked perfectly, and now I can continue to group different procedure Id's together and just keep updating my formula.

Thank you so very much!

lareya

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Crystal 8.5; ORSOS/One Call Hospital Scheduling System v9.3; SQL database; Huge Newbie to Crystal! Operating Room RN Analyst