If the stored procedure requires the prompts to run, you can't fill the values of dynamic prompts from that same stored procedure because it requires the prompt values and won't return anything until it has them. (Kind of a "chicken and egg" sort of conundrum...)
So, here's what you'll need to do:
For each dynamic parameter, add a table to the report that contains the data that should be in the parameter's list. Usually these types of tables are NOT the tables that your "real" data is in, they are tables that contain code/name lookups where the code is stored with your data and applications get the actual name by looking it up in the table.
DO NOT link these tables to anything! Crystal will complain that this is "generally not supported", but this will work for filling parameters.
In each of your parameters, use the data from one table only. DO NOT use these tables anywhere else in your report!
Also, please be aware that everyone answering questions here is a volunteer, you cannot expect to get immediate assistance with any questions, although we do try to check the forums frequently.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|