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 |
|
vaishanavi
Starting Member
9 Posts |
 Posted - 2009-03-19 : 05:06:03
|
| how do we display a dropdownlist with a collection of items in sql server reporting services |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2009-03-19 : 09:56:14
|
| Write a stored procedure to pull this and then call it in the report. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-19 : 14:23:55
|
| and make sure you map the values of parameter to this created dataset by means of from query option in parameter properties window |
|
|
|
vaishanavi
Starting Member
9 Posts |
Posted - 2009-03-20 : 03:58:36
|
| when we go to reporting servicesthere we found layout tabin that we have select left most corner and right click then we findreport parameter by selecting report parameteryou will found a dialog boxclick on add buttonspecify name,datatype,select radio button from query select dataset which you have previously binded to dropdown to display in outputclick okNow in preview tab you will find your dropdownlist with list of items |
|
|
|
|
|
|
Reporting services - generating a report