Adding the formula to the Parameters fields 1

[Ann28]

Hello,

I have a check_type parameter field on the report.
(allowed multiple values)
The user is prompt to choose V or P.

If the user would not select any only records with P
option will be displayed on the screen.

if the user did not select anything P & V should be displayed.

It should be a formula I think if the parameter is empty then display all P & V.
REALLY, APPRECIATE YOUR HELP!

 

[BobSuruncle]

You could modify the list of the values for your users to be like the following:
P
V
Both

You should also turn off the option "Allow Editing of Default Values . . . " on the parameter.

If the database field can ONLY contain P or V, then you don't need to make it a Multi-value parameter.
You'd modify your record selection formula as follows:

( {?CheckType} = "Both" 
  or {YourTable.YourField}={?CheckType} )

Bob Suruncle

 

[BobSuruncle]

Sorry, I forgot to include the formula to display the value chosen on the report.

If {?Checktype} = "Both" then "P & V Selected"
Else
{?Checktype} & " Selected"

Bob Suruncle