I am trying to pass 2 parameters to a filter for use.
1 paramater is the operator and the other paramter is the value being compared against.
So, I have field name ?op_param? ?value_param? in the filter.
This does not validate. Is there a way to get this to work?
I need the operator to be dynamic based on what the user selects, and the compared value to also be dynamic based on user selected.
Can I do this?
I am using 8v3 SP2.
I found that you cannot use an if stmt in a filter, but is there another option?
Refer to report studio user guide on proper syntax.
That's not the way to use a prompt filter.