Skip to Content
avatar image
Former Member

Crystal Reports - Multi-Select Parameter with Select Expert Formula

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 :(

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 21, 2016 at 10:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded