on 09-16-2015 3:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.