Question

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

+2

I create report in crystal reports, after I insert in IFS through “Create new Quick Report” window.

In crystal reports I enter multiple parameters. But in IFS how I pass multiple values in single parameter.

This topic has been closed for comments

Userlevel 5

+9

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,

Userlevel 5

+8

@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'

+2

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

First make sure your Crystal Parameter accepts multiple values. For the example below, the parameter is {?Site}.
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.

Sign up