2250737 - How to pass multiple custom values to a parameter in Crystal Reports?

How to pass multiple custom values to a parameter in Crystal Reports?

• Crystal Reports 2008
• SAP Crystal Reports 2011
• SAP Crystal Reports 2013
• SAP Crystal Reports 2016

1. Launch Crystal Reports designer
2. Create a report based on any database
3. Create a parameter and set the "Allow Multiple Values" option of the parameter to False
4. Go to Report menu>> Select Expert >> Record.
5. Select the field for which the filter is to be applied.
6. From the drop down, select 'Formula:'
7. If the 'Data Type' of the field is 'Number', enter the following formula:
   totext(<fieldname>,0)in split(<parameter>,",")
   If the 'Data Type' of the field is 'String', enter the following formula:
   totext(<fieldname>)in split(<parameter>,",")
8. Click on OK.
9. Now, refresh the report and enter multiple values seperated by comma(,).
10. The report should work fine and filter the data depending on the values entered.

 Note: Please find the Sample report from the attachments.

multiple values, parameter, cr, crystal, multiple custom values, crystal reports , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016