Report Parameter with Multiple Values

[Rarenugget]

Hi,

I'm trying to add a parameter to a dbForge Report and having trouble with the syntax.

The parameter Look-Up Setting is a Static List.


My filter string is currently [fund_class] Equals ?parameter1, where fund_class is the column in the query that the values mentioned above appear, and parameter1 is currently the name of the parameter.
I'd like to be able to click 'All' from the drop-down menu when I preview the report and have the report display all records with values 1, A, LP, or null.

What should my syntax be in the filter string and in the Look-Up Values?

Many thanks.

[alexa]

We will investigate this issue and will answer you as soon as possible.

[alexa]

This could be setup as follows

[Rarenugget]

Hi,
When I do this, I don't get the checkmark options in the parameter selection box, I get the following:


Could you show me what your parameter values look like in the above example? Is it a dynamic list or a static list?
Thanks.

[alexa]

Please see the screenshot