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

Restricting the list of values for a dynamic parameter

Dear all,

I have developed a report with one dynamic parameter. The list of values for this parameter shall be retrieved from column x in table A. However, not all values in column x shall be retrieved but only those that fulfill a specific condition based on other fields in table A, e. g. only the values of x in rows shall be displayed where column y = true AND column z = "some string".

Is there a way to achieve this with CR XI R2?

Thanks for any hints,

AnDi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 02:49 PM

    Hi,

    This is possible only when you create an Add Command.

    Generate your own SQL like :

    Select * from table where y=true and z= 'soem string'

    This will filter all the records and get the data into your report now you create a dynamic parameter at report level. The list of values will be based on off you SQL conditon.

    Thanks,

    Sastry

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Actually a command won't help in this instance. You can't pass a parameter value to a command and then turn around and use the command's result set as the LoV for a 2nd parameter.

      You actually need to be using a parameter with a cascading list of values. See CR's online help (F1) and search for "Creating a parameter with a cascading list of values".

      HTH,

      Jason

  • author's profile photo Former Member
    Former Member
    Posted on May 06, 2011 at 06:58 AM

    Dear Sastry,

    you solved my problem.

    Many thanks,

    AnDi

    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.