Symptom
To select all the members in a list in a paramater, have to select each member individually.
Reproducing the Issue
- Create a report with static parameter.
- Allow multiple values in the options of the parameter.
- Go to select expert and click on the field on which the parameter is based.
- Choose equal to from the first menu and the parameter from the second menu.
- Click on Record Selection formulas and write the following formula in it
- Refresh the report
- When prompted for the parameter, in "Enter a value" dialog box, write 'ALL' and click OK
- Now all the values will get displayed without choosing the values separately.
Resolution
- Create a report.
- Insert a static parameter based on a field.
- Click on Allow Multiple Values in the Options section and select true.
- Go to the Report Menu
- Click on Select Expert
- Select the field on which the parameter is based and click OK.
- In the menu, choose "is equal to".
- In the second menu, select the parameter. Click OK
- Go to the Report Menu
- Go to the Selection Formulas and then click on Record
- In the Record Selection Formula Editor, write the following formula:
if {?Parameter}='All' then true;
12. Click on Save and close to save the formula.
13. Refresh the report.
14. When pronpted for parameter values, In "Enter a value" dialog box, write "ALL" and click OK.
15. Click on the arrow mark next to it and click OK.
16. All the values of the parameter list can now be viewed without choosing the values separately.
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports XI R2
Attachments
screenshot1.bmp |