Skip to Content

Dynamic prompt not populating all DB Lovs in Crystal Report

Mar 16, 2017 at 01:03 PM


avatar image
Former Member

Hi Excperts,

I have created Parameter at Crystal level using List of Values as "Dynamic" option.

when I refresh the query I don't see all LOV.i see only one Value.

but when I use the same object in report I see all values.

Note: I am using Command prompt for this report not with tables.

I really would appreaite if any one could help on this


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

1 Answer

Abhilash Kumar
Mar 16, 2017 at 02:30 PM

Hi Prasad,

What is the 'source' of this dynamic prompt? Does the parameter refer to a field in the 'same' Command Object that is used as the report's datasource?

Please try this:

1. Go to the Database Expert > Expand existing connection name > Double click 'Add Command' > type in the following SQL query:

Select distinct table.field from table

Replace table.field with the database field you want the List of Values to be based off of.

2. Click OK and go to the Links tab. Delete any Joins that CR automatically adds to the other Command table.

3. Ignore the warning and click OK. Expand Field Explorer > Right-click the prompt > Edit > Choose 'dynamic' for List of Values.

Under 'Values', select the field from the NEW Command Object you added in Step 1.


10 |10000 characters needed characters left characters exceeded