Calling a Reporting Services report from a stored procedure

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.On Feb 20, 6:17 pm, derrick.cha...@.cox.net wrote:
> 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.
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