({?institute} = "" or {?institute}={INS.CODE})

Hi John,

Just some clarification here. I was recommending that you use an OR statment instead of the if-then statement as I hoped might address your other issue, although I have tested it further and it is interesting but not sure if it helps. Here is what I found ...My testing was using a param that allowed a user to type in the param option and add multiple selections to the param and a select statement using OR as I posted earlier.

It appears that you can add a "" to the Selected Values to avoid the 'Value is not Valid' warning when applying the params at run time. It the "" is the only selected item it will not apply any filter to the records. If a second value is added it will only apply that selection and ignore the "" in the select statement so it doesnot have to be removed from the selected values.

If you go with an "All" value (and change the select statement to use the "ALL nstead of "") and you leave ALL plus another selected value the ALL will take precedence and make the other selection moot.

 

Ultimately though a user must take some action at runtime to add a param value and I think adding the "" is more confusing then dealing with an ALL option as J had suggested.

 

Hope that helps.