SAP Knowledge Base Article - Public

1702428 - Optional Parameter based on LOV will be shown as empty when refreshing Crystal Report

Symptom

When setting a parameter to optional in Crystal Report, the parameters which are defined in the BEX Query Analyzer do not show any values anymore.

Environment

 

Crystal Reports for Enterprise 4.0

Reproducing the Issue

  1. Open CR 4 Enterprise
  2. Choose a BEX Query with at least one prompt
  3. Pick a dimension and a key figure in the Query Panel. let the report run and see that the LOV's or the BEX Variable appears and it shows values in dropdown box
  4. Change the query after retrieving filtered results
  5. Add a dimension object out of the CR4E query in as a filter
  6. Pick Prompt as value
  7. Set to "Optional Prompt"
  8. Run the Report again
  9. LOV content from BEX Query will not be available
  10. Uncheck the option "Optional Prompt"
  11. LOV connect will be available again

 

Cause

ADAPT01615599

The issue has been identified and logged under Problem Report ID

Resolution

 This issue has been addressed by BI 4 Service Pack 02 Patch 14

Keywords

 Empty parameter values, empty optional parameter values, Optional Prompt, empty LOV’s, Bex Query Analyzer, no values in prompt , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , Bug Filed

Product

SAP Crystal Reports all versions