How to pass multiple values in single parameter in IFS quick reports.

Hi @sumamatirmazi ,

Hope I understood this correctly.

you can pass the values for a single parameter separated by commas and then map it to the relevant parameter in the report. 

From crystal report side you have to delimit the input value and assign it to multiple parameters.

Thanks,

Best Regards,

@sumamatirmazi 

hello

try the text below.

It won't work in PLSQL, but it will work in IFS.

and ifsapp.report_sys.Parse_Parameter(upper(t.PART_NO),upper('&[-C--L]Malzeme_No')) = 'TRUE' 

Hi @sumamatirmazi ,

You can achieve this using the Split function in Crystal. Try the following steps.

1. First make sure your Crystal Parameter accepts multiple values. For the example below, the parameter is {?Site}.
2. In the record selection formula, enter the following text .

         {SALES_PART\.CONTRACT} = Split({?Site}[1],",")

      3. Save the report and place in your Crystal runtime.

      4. In IFS, run the Crystal quick report and enter multiple site values as a single parameter                entry delimited by commas.

          For e.g. 10,30,40

      5. Click Ok and you should be able to see the data show up for sites 10, 30 and 40.