SAP Knowledge Base Article - Public

1256206 - Viewing entire list of parameters instead of viewing them individually

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

  1. Create a report.
  2. Insert a static parameter based on a field.
  3. Click on Allow Multiple Values  in the Options section and select true.
  4. Go to the Report Menu
  5. Click on Select Expert
  6. Select the field on which the parameter is based and click OK.
  7. In the menu, choose "is equal to".
  8. In the second menu, select the parameter. Click OK
  9. Go to the Report Menu
  10. Go to the Selection Formulas and then click on Record
  11. 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