sql server reporting services: Calling a Reporting Services report from a stored procedure -- sql server reporting services

Calling a Reporting Services report from a stored procedure

derrick.chapin NO[at]SPAM cox.net
2/20/2007 4:17:28 PM

sql server reporting services:

Hello and thank you for any assistance that you can provide.

I am looking for a way to simply print out a Reporting Services report
from a stored procedure with zero user interaction.

I have very little knowledge of advanced stored procedure usage other
than T-SQL commands but I imagine it cant be very hard to do.

Thanks again for any help you got.

Re: Calling a Reporting Services report from a stored procedure

EMartinez
2/20/2007 7:46:00 PM

[quoted text, click to view]

I'm a little fuzzy in this area; but you should be able to use: exec
xp_cmdshell "rs.exe -i LocationOfRDLFile -s ServerURL -v
VariablesAndValues" inside a stored procedure and then have a way to
print it afterwards. Hope this helps.

Regards,

Enrique Martinez
Sr. SQL Server Developer