execute ssrs report from stored procedure

[zarkon4]

I have a stored procedure that gets executed daily, it checks a table in the database to see if the current date equals the month end date. If it does then it processes and executes other store procedures.
I have an ssrs report that needs to be ran and distributed from within the stored procedure. I have been searching and have come across other similar needs but no solution. Would anyone know how to do this, or lead me in the proper direction to accomplish this?

Thanks in advance

 

[simian336]

If your condition exist you could email out a link to the report.

Simi

 

[zarkon4]

I could not do that. I would be performing some table updates from within the stored procedure after the report. These updates would "clean up" the criteria for my report and no data would show up on it.

 

[simian336]

Can you send a query rather then a report?

Simi

 

[zarkon4]

I think what I will do is change the sp to dump the data off into a temp table for the report to use. then perorm the maint. It just woul dbe nice to be able to run a report from an sp.

 

[Rhys666]

I think you're approaching this the wrong way round. Any dB processing should be just that, dB processing, and that shouldn't have anything to do with SSRS. If your dB has a back end process that processes and transforms the data appropriately, can't you then just set up an SSRS subscription to handle the dissemination of the report?

Rhys

"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
Terry Pratchett