Dynamic Parameters based on Stored Proceedures

[SDB15]

I'm using a stored proceedure to define a custom set of choices delivered to a dynamic parameter. Works like a charm in standard reports. The problem is when I run it against a report that uses another stored proceedure, it wants me to fill in the parameters for the other proceedure before it will give me the pick list. This is user unfriendly so I'm trying to find a way around it. Any ideas?

 

[Madawc]

Put the other stored procedure in a subreport. Pass down the parameter, using Edit > Subreport Link.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[SDB15]

Worked perfectly after I figured out how to match the parameters' data types in SQL. (turns out SQL dates are always DATETIME fields)

Thanks!