2005499 - How to "auto-populate" dynamic cascading parameters

SAP Knowledge Base Article - Public

2005499 - How to "auto-populate" dynamic cascading parameters

Symptom

  • Requirement for a dynamic cascading parameter containing Country, Region and City:
    • If user selects Country and no Region, parameter should display all Regions for the Country
    • If user selects Country and Region, but no City, the parameter should display all Cities for teh Region.

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2011
  • SAP Crystal Reports, Developer Version for Visual Studio .NET

Resolution

  • Ensure that each of the prompts is set as "Optional".
  • Use the following Record Selection Formula:

 

(Not HasValue({?Country}) OR {?Country} = {Country})
AND
(Not HasValue({?Region}) OR {?Region} = {Region})
AND
(Not HasValue({?City}) OR {?City} = {City})

Keywords

LOV CR CRVS 2010 2013 2013 CR4VS param , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports, developer version for Microsoft Visual Studio