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 |
|
stonebreaker
Yak Posting Veteran
92 Posts |
 Posted - 2009-11-10 : 12:04:48
|
| I am modifying a legacy report to be used by multiple clients. As such, I need to pass a companyID variable to the stored procs. However, my variables window is deactivated. Rather, the Add Variable and other buttons at the top of the window are grayed out. Is there any way to turn them on? Thanks,Stonebreaker |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-10 : 13:11:51
|
| you just need to add companyID as a new parameter and then pass it down in your query/procedure |
 |
|
|
stonebreaker
Yak Posting Veteran
92 Posts |
Posted - 2009-11-12 : 13:53:15
|
| Thanks. Didn't realize the parameters could be passed to stored procs. |
|
|
|
|
|
|
Cannot add variables to report