SAP Knowledge Base Article - Public

1568993 - The value set for the option ‘Allow Multiple Value’ for dynamic cascading parameter is not retained in Property Browser in Business View Manager in BOE3.1

Symptom

The value set for the option ‘Allow Multiple Value’ while creating the dynamic cascading parameter is not retained in Property Browser in Business View Manager in BOE3.1

Example:

Dynamic Cascading Parameter(Customer> Region>City ) created in the Business View.

The option Allow Multiple Value = True for all the parmeter field(Customer>Region>City) within the parameter wizard, which is set to false for city in the Property browser. 

Environment

  • Crystal Reports 2008 Service Pack 3 Fix Pack 3.5
  • Business Objects XI 3.1 Service Pack 3 Fix Pack 3.5

Reproducing the Issue

1.Open Business View Manager.

2.Create a Data Foundation based on Xtreme Sample Database.

3.Create a Business Element based on the same Data Foundation.

4.Create a Business View based on the same Business Element.

5.Create a cascading dynamic parameter withine the Business Element.

   Example Country> Region>City.

6.Edit the parameter wizard for Country, Region and City set the option Allow multiple value = True for all the parameter fields, save and close the edit Parameter wizard.

7.Check the option "Allow multiple value " in Property Browser for all the parameter fields i.e Country, Region and City.

8.In the Property Browser the Allow multiple value = True only for the field which is at the lowest level among all the cascading parameters field.

   For example in Country, Region and City, city is at the lowest level for which the option

   Allow multiple value = False for Country.

   Allow multiple value = False for Region.

   Allow multiple value = True for City.

9.Save the Business View.

10.Open the Crystal Report Designer.

11.Select Database Expert.

12. Select create new connection.

13.Select Repository> Select the Business Element containing the dynamic cascading parameter.

14.Now insert the parameter on the report.

15.Click on the refresh icon or press F5 short cut key.

    The report will be refreshed and will prompt to enter the multiple values on the report for Country, Region and City.

16.Save and close crystal report.

17.Restart Crystal Reports.

18.Open the edit parameter wizard for Country, Region and City on Crystal reports.

19.The Allow Multiple Value = True only for City. It is set to false for Region and Country.

20.Create a formula which takes the count of the no of fields selected runtime for Country, Region and City such as for count({Business Element.Region}).

     Now the formula field fails since the Allow Multiple Value = True only for City and for Country and Region it is false.

Cause

The issue has been identified and logged under Problem Report ID ADAPT01533154.

Resolution

The issue is currently under review by the Product Group and targeted to be fixed in Fix Pack 3.6 for Crystal Reports 2008 Service Pack 3.

Keywords

ADAPT, Allow multiple value,Dynamic Parameter, BV, BE, CR , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1