Replies posted by ENSVINOJEE

1 Reply

S
Do Gooder
sumamatirmaziDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

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

Hi @sumamatirmazi , 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. 

3
E
Do Gooder (Partner)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings