Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-05 : 07:30:53
|
| Lisa writes "I created a report(report is executed by one store procedure) using visual Studio 2000 and the user wants to be able to filter out data by using a drop down menu after the report has been generated, is this possible and if so what steps should I take?" |
|
|
jhermiz
3564 Posts |
Posted - 2006-12-05 : 07:48:48
|
A drop down is simply a parameter in your report so yup this is possible. Look at the menu "Reports" in visual studio and select parameters. You will need to modify your stored procedure to take in that same parameter name / type.Once you do that you may have to right click on your .rdl file and view the code and make sure the parameters section has that one parameter you created (for some odd reason the changes dont always propogate to the rdl code side, bug in RS).Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
Microsoft SQL Server 2005 Reporting Services