Skip to Content
author's profile photo
Former Member

Restricting the list of values for a dynamic parameter

Posted on May 04, 2011 at 09:46 AM 6 Views

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

SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    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 comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      May 05, 2011 at 06:02 PM

      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
    Posted on May 06, 2011 at 06:58 AM

    Dear Sastry,

    you solved my problem.

    Many thanks,

    AnDi

    Add comment
    10|10000 characters needed characters exceeded