Hi I would like to give the users of a report the ability to call a stored procedure which receives the value of the cell as a parameter. Is this possible in SSRS 2005?

One way of doing it: drill-through to new parameter report with stored procedure and pass the cell value for parameter.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

If you dont want to open a new report, you can also just call the same report again. For that follow the steps below:- 1) Create a new parameter with default value of 0, say PAR_Value 2) Create a new dataset in your report and call the required stored procedure by passing PAR_Value (Before this, add a logic in your stored procedure such that if PAR_Value is 0, dont do any operation else do the required operation. This logic can be implemented in different ways also, like if you dont want to touch your original stored procedure, then just create a new stored procedure which call the former if PAR_Value is not 0) 3) Add a drillthrough action and call the same report. All existing parameter values should be passed but for PAR_Value, the value of the required cell should be passed, Now when the drillthrough happens, PAR_Value will have a value other than 0 and hence the procedure shgould get called with PAR_Value as the input. Care should be taken to change the 0 value into something else if you actually expect to have data values for PAR_Flag as 0Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)