Skip to Content
avatar image
Former Member

Command uses Static Parameter. Want to add a dynamic parameter for aditional selection criteria

I am using CR2016 SP2. I just have a main report, no sub-reports. I have a Command that uses a static parameter. That works fine.

I would like to add additional record selection criteria outside of the command, based on a dynamic parameter (a list of values from a DB table). I create the dynamic parameter, but it does not display any values.

Would appreciate help with this; I have tried a lot of things, but nothing has worked.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 22, 2017 at 08:09 PM

    It should be possible if:

    1. you add the DB Table as a second connection to the report

    2. do not link the command and DB Table

    3. Create a new Dynamic Parameter of the DB table

    4. DO NOT use any field from the DB table in the report. DB Table only for the parameter.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2017 at 06:45 PM

    Hi,

    Thanks for your reply. I think I have another layer to the question, if I can provide a litte more info... I'm trying to create a Crystal report where the Command uses a static parameter, and where the 'Record Selection Formula' can use values from a dynamic parameter (values from DB table).

    The parameter for the Command is working. However, the dynamic parameter is not getting populated with the List of values.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded