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 |
|
pvong
Yak Posting Veteran
58 Posts |
 Posted - 2013-01-18 : 10:10:38
|
| I'm new at this SSRS thing and I'm using SQL 2008 R2. I have a simple drop down option that says page1 and page2. Is it possible to have a event that when you hit view report it will run some codes in the background?If Page1, then paramA=123if Page2, than paramA=789Am I just not seeing it. Just want to change some param values based on the dropdown selection.Thanks!------------------------------Using VS2010 / Learning in VB.Net / Win2008 R2 / SQL 2008 R2Be kind to the newbies because you were once there. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-18 : 13:43:23
|
| you can set it in parameters tab under default value by giving an expression like=IIF(Parameters!Param.value="Page1",123,789)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Page Load Event from a drop down in SSRS - is it p