SAP Knowledge Base Article - Public

1839936 - Dynamic Parameters become Static on doing "Set DataSource Location" in Crystal Reports based on Command Object

Symptom

Dynamic Parameters change to Static when changing the data source location of Crystal report based on Command Object.

Environment

Crystal Reports 2008 V1

Reproducing the Issue

  1. Create a List of Value (LOV) by name "Test" in Business View Manager on one database string field <Field> from database table <Table>.
  2. Create two ODBC DSNs pointing to the same database and name them as "Con1" and "Con2".
  3. Launch Crystal Reports 2008 V1, create a new report on "Command Object" pointing to "Con1".
  4. Create a command level string parameter "Param" and use it in the custom command.
  5. This parameter would show up in Field Explorer by name "Param".
  6. Edit the parameter, it would appear by default as "Static".
  7. From "List of Values" drop down on "Edit Parameter" window, change it to "Dynamic".
  8. In "Choose a Data Source" section select "Existing" radio button and select the "Test" LOV created in step 1 and click on OK.
  9. Refresh the report, it would show dynamic list of values.
  10. Click on "Database" from standard toolbar and select "Set Datasource Location".
  11. Change the datasource of command with "Add Command" from "Con2".
  12. Create a command level string parameter "Param1" and use it in the custom command which is pointing to "Con2".
  13. Once the Current Data Source on "Set Datasource Location" window shows as "Con2" click on Close.
  14. Check the properties of the parameter in Field Explorer, it will show as Static.

Cause

The command level string parameter for the Command Object pointing to "Con2" was created with a different name.

Resolution

  1. Repeat steps 1 to 11 given above.
  2. Create a command level string parameter "Param" and use it in the custom command which is pointing to "Con2".
  3. Once the Current Data Source on "Set Datasource Location" window shows as "Con2" click on Close.
  4. Check the properties of the parameter in Field Explorer, it will show as Dynamic.

Keywords

Dynamic parameter changing to static, dynamic to static, dynamic, static, crystal reports on command object, crystal reports, CR 2008 V1 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1