Displaying Multiple Parameters on Report Header

[AJANETA]

I have setup a parameter field with multiple options and I want the user to be able to either select one, select more than one OR select ALL.

I have placed the field on the report header, however it only prints the one of the options selected I have read that I may need to use an Array, however I am not sure where to start.

Can you help with the following questions.

a) If the user selects more than one parameter how do I display them on the report.

b) Instead of the user selecting multiple parameters, can I give them an option to select all the parameters available.

Regards

Janet Anderson
Database Manger

 

[synapsevampire]

For the best results, post specifics, such as version of CR, and type of parameter.

To simplify, I'd use a string type of parameter, and use something akin to the following in a formula to display them:

"You selected " + join({?parm},", &quot

I generally make the first choice in the parameter = "All"

Then in the record selection formula (Report->Edit Selection Formula->Record) use:

(
if {?parm}[1] <> &quot;All&quot; then
{table.field} = {?parm}
else
true
)

Which will either pass the choices, or pass nothing, which results in all rows. I couldn't test the syntax, but the theory is correct.

-k