Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.