Skip to Content
author's profile photo Former Member
Former Member

Allow multiple values for parameter is disabled in Crystal Report 2011

We are planning to migrate our all reports from Crystal Report XI R2 to Crystal Report 2011 in BO 4.0 environment. We have used oracle's Stored Procedures that returns cursor to build reports. In older version, we had an option to make SP's parameter to allow multi-select but it's disabled in CR 2011. We have such a 50 reports and if Crystal reports stops this feature in newer versions, we have huge impact in our current product. We are also using in-built export functionality as well. Is there any work around for the same?

Let me explain requirement step by step:

  1. We want to migrate CR XI R2 to CR 2011 in BO 4.0 environment.
  2. We are extensively using Oracle's stored procedure to create report.
  3. We have around 50 reports that have multi-select features and it's one of the key feature of our system. We are also using export to excel and CSV functionality for all the reports.
  4. In prior version, multi-select value is passed as comma separated value and CR 2011 is passing as an array so is there any work around for the same as well.

Main Objectives:

  • Need solution for enabling multi-select parameter for Stored Procedure's parameter in CR 2011 in BO 4.0 environment.
  • Need solution for converting an multi-select values to comma separate value and pass to Stored Procedure in CR 2011 in BO 4.0 environment.

I have tried my best to explain the scenario. Let me know if you need more information to provide solutions.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 11, 2013 at 04:39 PM

    The only way I know of to handle this depends on not having any subreports in the report that your trying to configure.

    1. Create a "main" report that has all of your parameters. If any of these are dynamic parameters, they should be configured separately in the Business View Manager. Because you have to have at least one record in the report in order for it to run, I usually create a command that simply has something like this in it:

    Select Sysdate from dual

    This will give you the run date of the report.

    2. Create a formula that will take the array from any multi-select parameters and convert each to a comma-delimited string.

    3. Add the original report as a subreport.

    4. For each parameter, link from either the single value parameter or the formula that creates the comma-delimited string to the corresponding parameter in the subreport by using the drop-down in the bottom-left of the Subreport Links screen - do not use "Select data in subreport based on field" on the bottom-right.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 11, 2013 at 05:27 PM

    hi Jigar Acharya,

    if you have a situation where a feature that you rely on is no longer in a current version or no longer working in a current version then you should contact customer assurance. ask them to escalate the issue as this is stopping you from migrating to a newer landscape.

    before contacting customer assurance though ensure that you've got your production sandbox system patched to the latest level as this is something that they will usually insist on.

    -jamie

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.