on 03-15-2018 5:47 PM
Please note that the application where the reports are run from do not support optional parameter so we have to use the (if parameter='Y' then field=values else 1=1) workaround.
I have 6 parameters which will display as checkboxes to the user (checked is yes, not is no). If they check say 4/6 checkboxes, I need the report to print for those 4 values and not the other 2. Basically I can't really use if parameter='Y' then field=value because I need it to include a list of values ie if 4 parameters have Y, then include values 1, 2, 3, 4 in the report selection. I need to somehow generate a value list from the parameters used then use that list in the report selection ie Field in (list)?
Can you something like this, I have assumed all fields are strings so else = 2 single quotes and assumes '' is not a valid result, change else result depending on data type
(Field1 = (If Param1 = 'Y' then Field1 else ''))
Or
(Field2 = (If Param2 = 'Y' then Field2 else ''))
Or .....
Not familiar with your data structure so this might not work
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.