grouping formula assistance 1

[catchingup]

I am trying to get my report properly grouped so that it displays a specific unit or all units available.

I am using CR11

what i have set up is as follows:

GROUP 1 -- UNIT (Ascending)
GROUP 2 -- UNIT ISSUE # (Ascending)
DETAILS -- Description, etc.

I have a parameter built in which asks the user to select a specific UNIT or ALL UNITs.

The selection criteria is set to have the {?Unit} = {Unit} if {?Unit} <> "ALL UNITS".

The way i have it set up it is working for specific UNITs but not for ALL UNITs.

Can anyone provide assistance for how I can updated the selection criteria or anything to get this to work for ALL UNITS?

 

[lbass]

(
if {?Unit} <> "ALL UNITS" then
{table.unit} = {?Unit} else
if {?Unit} = "ALL UNITS" then
true
)

You need to have a parameter option "ALL UNITS" in your list of values when you set up the parameter.

-LB

 

[catchingup]

Thank you! It worked exactly as I needed. I knew I was dancing around what i needed! Have a great weekend!