cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports - Multi-Select Parameter with Select Expert Formula

Former Member
0 Kudos

Hello, I've been asked to amend a crystal report to include the following:

  • A multi-select parameter to allow the user to select which activity codes (1BW, 1QI, 1FA) they would like to include in the report
  • If they select '1QI', the report also needs to show items for '1MM' and '1OCW'
  • If they select '1FA', the report also needs to show items for '2MAN'

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 😞

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

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