sql server reporting services: We have an app that calculates invoice values. We would like to immediately
trigger it to print a reporting services based invoice. How do we pass the
variables from a stored procedure and start a reporting services based
report.

As with a previous post, we could call a c# app that would start reporting
services, but we want to go straight from the sp to rs.

One way to do it would be to write a command-line app (script/C#/VB .NET)
that prints the report(s) and call it from the stored procedure using
xp_cmdshell.

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

I would build a facade web service which will run the report. Then, I will
invoke the web service from inside a table trigger. If you download the
Database project from my book source code which is available on the
publisher's website, you will find a trigger trgSpecialOffer which executes
the spUpdateRssFeed stored procedure. This sp invokes a web method using the
ServerXMLHttp object. This should be enough to get you started.
--
Hope this helps.

-----------------------------------------------------
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]

One thing we are considering is setting up a data driven subscription which
runs at 5minute intervals. We have a queue which feeds the DDS's query
(actually a stored procedure) and the entry in the queue is then marked as
processed in the stored procedure.

[quoted text, click to view]