Using a Stored Procedure to Run a Report 1

[robwilliams71]

Hi,

Not sure if this is possible, but can I run and print a report from a stored procedure? Basically I dont want the users getting to Reporting Services via web app.

Thanks
Rob

 

[mrdenny]

Technically you could, but it wouldn't be recommended. It would be much better to call the Reporting Service WebMethod directly and have it pull the report into your application. If you want you have have the API spit it out as a PDF which would then be ready for printing.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog