After migration from data-push to data-pull mode, Crystal Reports do not allow selection of multiple values in dynamic parameters

Resolving The Problem

In order to bypass this problem, a parent report need to be created for the problematic report.
The problematic report needs to be inserted in the parent report as a sub-report.
Add to the parent report all parameters that are required by the problematic report.

One formula for each parameter that requires multiple values will also be needed.

Review the following 3 notes before proceeding to the solution.

Note 1: Before you start, check the JRC version and make sure you are using the Crystal Reports JRC 12.x runtime. If your are using old version e.g. CR JRC 11.x, please do the following steps:

1. Download a new version of JRC 12.x from the SAP web site.
• The Link is: (Please click 'download' link in this page to jump to the real download web page)http://www.businessobjects.com/campaigns/forms/downloads/crystal/eclipse/datasave.asp
• In the Runtime Libraries section, JRC 12 version can be found.
  
  
2. Navigate to the directory where configureJRC is deployed in Rational ClearQuest
   
   Example: %CLEARQUEST_HOME%\cqweb\cqwebprofile\installedApps\dfltCell\RationalClearQuestWebReport.ear\CQWebReportModule.war
   
   
3. Run configureJRC remove
   
   
4. Copy JRC 12.x to the path in step 2
   
   
5. Run configureJRC12 <yourJRC12FileName>.zip
   
   
6. Restart the ClearQuest Web server profile

1. Migrate reports that are based on dynamic query from data-push to data-pull mode with CRMT (Crystal report migration tool). Review the Rational ClearQuest Knowledge Center for more details.
   
   
2. Open Crystal report designer and create a parent report as follows:
   
   2.1. Create a blank report to server as parent report.
   
   
   2.2. In Field Explorer pane, right click on Parameter Fields and choose New... to create one or more multiple values parameters with any reasonable name for parent report. These parameters need to correspond one by one with the parameters that are required by the migrated report (If migrated report has 3 parameters, then create 3 parameters with similar names).
   
   Example: There is one parameter ParameterA in problem report, create one parameter named ParameterA_parent in parent report.
   
   
   2.3. In the Edit Parameter windows, for Allow Multiple Values option, select True from dropdown list; and for List of Values option, select Dynamic from drop-down list.
   
   
   2.4. Provide selectable values for this parameter in parent report.
   
   
   2.5. In parent report, create one formula for each parameter that requires multiple values.
   Use names such as formulaForParameterA to easily associate them with the relevant parameter. This formula will convert multiple the values to a string.
   
   The formula needs to be like this exactly:
   
   '######_' + Join({?ParameterA_parent},",")
   
   Where ParameterA_parent is the name of multiple parameter you created in step 2.1.
   
   
   2.6. Suppress the Report Header and Details section of parent report since we don't need them.
   
   
   2.7. Select Insert - Subreport on parent report, to insert the migrated report (the one migrated from push to pull) as a subreport in the Report Footer section (actually any section will be fine).
   
   
   2.8. Link the formula (for example formulaForParameterA) to the sub report corresponding parameter that requires a multiple-value:
   
   1. Right click on the subreport and select Change Subreport Link.
   2. In the Change Subreport Link window, select the formula formulaForParameterA in the upper left corner list and click on the arrow >, to bring it in the Field to link to list.
   3. In the bottom left corner, select the sub report parameter you want to associate with this formula (for example ParameterA) from the drop-down list .
   4. Click OK
   5. Save all changes
   
   
   2.9. Do step 2.8 for all parameters.
   * If it is a multiple parameter, do as in step 2.8.
   * If it is a single value parameter, link it to migrated report directly (without using Formula).
   
   
   2.10. Preview the parent report.
   You will be prompted by a dialog to enter multiple values as parameters. Enter multiple values. The report should be displayed correctly based on the values just input.
   You can also execute report in report launcher by copying the parent report to working directory of launcher. The migrated doesn't need to be copied.