Skip to Content
avatar image
Former Member

Dynamic Prompts

HI all,

we have using some stored procedures to retrieve the data to Crystal reports

country , state parameters to the stored procedure

created parameters in the command there is no list of values for country and state

how to get list of values of Country and with respect to country state list of values has to change

Please Advise


Krishna M

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 16, 2015 at 02:59 PM

    Hi Krishna,

    Here's what you need to do:

    1) Open the Database Expert > Expand the database connection > Select 'Add Command' and type in a SQL Query to generate the List of Values. E,g:

    Select Distinct table.field from table

    2) Go to the Links tab and Delete any links from this table to the SP. CR will throw a warning that you can ignore

    3) Open the Field Explorer > Right-click the prompt > Edit > Select 'Dynamic' under 'List of Values'. Under the 'Value' column, choose the field from the 'Command Object'.


    Add comment
    10|10000 characters needed characters exceeded