Skip to Content
avatar image
Former Member

Dynamic prompt not populating all DB Lovs in Crystal Report

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

Prasad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded