Taking the Default while using Parameter 1

[nvtjellis]

In the report the parameter allows for multiple single entries. However if I want select all the records how can I default?

Example: parameter accepts: AZ MO WI DE SD ND. This will give me all the records for these states. What would I code to get default for all 50 states?

 

[vidru]

Set up your default parameter list with 'ALL' as the first value. Even if the users don't hit the 'Add' button, it still sees it as the current value (at least it does in CR 8.5). Then set up your Record Selection Formula like this:

if not ('ALL' in {?States}) then
{Table.State} in {?States}
else if 'ALL' in {?States} then
true

If they don't choose a state, it should pick up all states... and it should pass to the database.

-dave