SAP Knowledge Base Article - Public

1607058 - What is the Operator used between Record and Group Selection Formulas in Crystal Reports

Symptom

  • What is the Operator used between Record and Group Selection Formulas

Environment

Crystal Reports 2008, 2011

Resolution

  1. AND operator is implicitly applied between any Record Selection Formula and Group Selection Formula used in Crystal Reports.
  2. For Example: Say we have Crystal Report with Country, Region, Sales Revenue fields
  3. Apply Group level Selection formula : Country in ('USA','India')
  4. So report now will show Sales Revenue for USA, India.
  5. Now Apply Record level Selection Formula: Region ='MI'
  6. So report now shows sales revenue data for Region ='MI' alone
  7. Hence we can confirm that data is displayed that satisfies Country in ('USA','India') AND Region='MI'.

Keywords

Operator used between Record and Group Selection Formula , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports XI