Skip to Content
0

Crystal Reports - Multi-Select Parameter with Select Expert Formula

Oct 21, 2016 at 08:56 AM

56

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Oct 21, 2016 at 10:51 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded