on 10-21-2016 9:56 AM
Hello, I've been asked to amend a crystal report to include the following:
Bear in mind, it is likely that the user could select all three codes, so the report (potentially) needs to include results for all of the above activity codes.
I'm fairly new to crystal so it's proving quite difficult to get my head around, and everything I've tried so far hasn't worked.
I'm guessing I need some form of IF statement to say if *multi-select parameter* includes 1QI, display results for 1QI, 1MM and 1OCW and then if *same parameter* includes 1FA, display results for 1FA and 2MAN. But there may be a simpler way to do this.
Any help would be greatly appreciated as I'm being pushed to get this completed asap 😞
Hi Chris,
Create a selection formula like so:
'1QI' IN {?Multi select prompt} AND {Database field} IN ['1QI', '1MM', '10CW']
OR
'1FA' IN {?Multi select prompt} AND {Database field} IN ['1FA', '2MAN']
OR
'1BW' IN {?Multi select prompt} AND {Database field} = '1BW'
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.