Skip to Content
0

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

Jun 22, 2017 at 01:16 AM

56

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vitaly Izmaylov
Jun 22, 2017 at 08:09 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 23, 2017 at 06:45 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded