Crystal Reports XI, SQL Server 2005
I have a report that calls a complex stored proc in SQL Server as the datasource (it has 8 parameters). We've been asked to make one of the parameters a dynamic drop-down but the only examples and info I've seen used tables as the data source. Is it possible to use a dynamic drop down with a stored procedure and if so, suggestions on implementation? Everything I have tried has returned an error. Thanks.