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 |
|
Fletch
Starting Member
29 Posts |
 Posted - 2005-09-15 : 06:49:20
|
| I know reporting services *reports* - but is it possible to also fire a stored procedure to update the database!?I have a list of dates in a report (in a table) and I'd like the option to add them to a database table.thanks for any help,Steve. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-15 : 12:45:11
|
Since you can call stored procedures from RS and stored procedures can have UPDATE statements, then yes you can have a report update the database.quote:
I have a list of dates in a report (in a table) and I'd like the option to add them to a database table.
This specific requirement though would be tricky. I think you'd have to write a custom DLL that you attach to the report and call it for each date in the table.Tara |
 |
|
|
|
|
|
Update database