-
March 24th, 2009, 02:56 PM
#1
drop down parameter with stored proc?
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.
-
March 26th, 2009, 04:48 AM
#2
Re: drop down parameter with stored proc?
easiest way would be to front the report with a vb/c# front end then pass the parameters as a part of the call to the report.
If you find my answers helpful, dont forget to rate me
-
March 26th, 2009, 11:22 AM
#3
Re: drop down parameter with stored proc?
Could You edit that parameter in Crystal Reports as Allow Multiple Values and Set Default Values
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|