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

[MPBL]

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.

[MPBL]

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.

[vitaly_izmaylov]

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.