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.
Report Parameter with Multiple Values
Re: Report Parameter with Multiple Values
We will investigate this issue and will answer you as soon as possible.
-
- Posts: 2
- Joined: Wed 28 Mar 2018 20:35
Re: Report Parameter with Multiple Values
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.
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.