I made a copy of report which has several sub reports using a new stored procedures which pulls data from another DB. Problem is that when I set the prompts to dynamic select the field the from stored procedure the does not fill the prompt list from the DB when report is run.

Thanks for any help

Edited by godistop1 - 04 Aug 2014 at 10:05am

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

Edited by hilfy - 01 Aug 2014 at 9:06am