Having problems leaving null Parameters

[ramblinrose]

I have a report that has multiple parameters. Two of the parameters are dynamic. I need to be able to have the report use either one of those parameters or both.

For example:

Dynamic Parameter 1 (Nurse)
Dynamic Parameter 2 (Location)

The end user needs to be able to run the report by either selecting a nurse or selecting a location or both. When I leave one of the parameters empty, it displays the message "The value is not valid".

In my record selection formula I am testing for the parameters being null.

 

[kskid]

Insert a default value of "ALL" in both parameters.

In your record selection

(
If {?Nurse} <> "ALL" then
{table.nurse} = {?Nurse}
else
True
) and
(
If {?Location} <> "ALL" then
{table.Location} = {?Location}
else
True
)

-lw

 

[ramblinrose]

I cannot insert default values in dynamic parameters.

 

[lbass]

You could create a command for each parameter that adds the "All" option, like this:

select table.`nurse`
from table
union
select 'All'
from table

Use the command only to populate the dynamic picklist (do not link it or reference it in the main report), and then use kskid's selection formula.

-LB