Dynamic Prompts

[former_member202170]

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

Thanks

Krishna M

[abhilash_kumar]

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

-Abhilash

[former_member202170]

when i am trying to do that

the prompt is raising twice.... I don't know why

i had created SQL statement added a new command and attached the dynamic prompts to new field

Please advise

Thanks

Krishna M

[DellSC]

You need to edit the parameter that was created when the stored proc was added to the report to make that dynamic.  Do not create a new parameter for this.

-Dell