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 |
|
naveenjv
Starting Member
9 Posts |
 Posted - 2011-07-28 : 05:57:13
|
| Hi,I am using SQL Server 2005 SSRS. I have created 2 data sets based on two stored procedures (SPs). I wanted to use output (one of the fields) of my first SP used in first data set as an input to the one of the input parameter of second SP, data set. How to achive this using BIDS - SSRS?Example: If I select market_1 in first drop down, drop down 2 should be filtered based on market_1 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-29 : 02:45:00
|
| you can make use of cascading parameters for thishttp://msdn.microsoft.com/en-us/library/aa337169(v=sql.90).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSRS: Output (field value) of an SP to be used as