Multiple Parameters Question

[deemat]

Trying to figure out a way to do this. Using CRXI for reporting. In the report, I have two parameters, one for the user to select an ID the other for the user to select a date range. Does anyone know if there is a way to use either of the parameters and not have to select a value for both to get the report to pull data? If the user only wanted to see all data for that particular ID without having a date range for instance.

Thanks

 

[lbass]

CR XI requires and entry for all parameters, so try the following:

Set up a default value for the range or instruct the user to enter a default value like 9999/9/9 and same for the ID, e.g., 0.

Add prompt text like this: If you would like to select data based on a date range then selected a date range; otherwise, enter 9999/9/9 for both.

Repeat for the ID prompt.

Then set up a selection formula like this:

(
(
minimum({?DateRange})<>date(9999,9,9) and
{table.date}={?DateRange}
) or
minimum({?DateRange})=date(9999,9,9)
) and
(
(
{?ID}<>0 and
{table.ID} = {?ID}
) or
{?ID}=0
)

-LB