Conditional Parameters

[geestrong]

Hello

Using CR XI on Oracle 8

I am trying to create a conditional parameter that can select a single value or select all the value. I have come across one thread that had code. The thread was vague about where to place this code.

Here is my code:
If {?agency}<> 'ALL'
then
{per_action.agency_code} = {?agency}
else if
{?agency}='ALL'
then
TRUE

I have append all the value from table and added 'ALL' to the parameter list. Trying to figure how to associate "ALL" to return all the agencies?

Thanks,

 

[asterix62]

Try this:


If {?agency}= 'ALL'
then True
else
{per_action.agency_code} = {?agency}

 

[geestrong]

Thanks for the quick response,

My issue is where to place this code.. Is it place within a formula and the selection expert reference it or is placed somewhere else?

 

[asterix62]

You have to place it in Report -->>>selection formulas --->> record

 

[geestrong]

Thanks asterix62 it worked!