Replacing where clause dynamically in query
In my report query I have a where clause that needs to be replaced dynamically based on the data chosen in the front end.
The query is something like :
I already have a code to replace the value - I created report parameter and linked to the value ? in the query.
Any value of name that comes from front end replaces the ? in the where clause - this works fine.
But now I need to replace the entire clause. Should I create two parameters and link them to both the '?' ?
Can anyone help with this?