SAP Knowledge Base Article - Public

1202605 - How to display only one prompt parameter in Crystal Reports based on two universe queries which use a similar filter

Symptom

  • Create a Crystal report with two queries from a universe.
  • The two queries use the same dimension as their filter when adding these two queries to the report data source.
  • Place some fields from queries into the report.
  • When you refresh this report, you are prompted for two parameters with the same name.

Can you merge these two parameters into one?

Resolution

Use the same name for the two queries in the Business Objects Query Panel when you add these queries as the report data sources.

When you refresh the report, only one parameter displays in the prompt window.

Keywords

merge,one,prompt,parameter,universe queries,filter , 6177467 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2