Wednesday, March 28, 2012

How to make report server email a report on request?

Rather than use a schedule to email a report, I want to get the report
server to email a report on request from a batch job.
Is it possible to do this by issuing a single HTTP url to the report server?
--
McGeeky
http://mcgeeky.blogspot.comTry this:
1. Schedule the report to send an e-mail the way you want it. Set the next
run time to yesterday at this time. Save the schedule.
2. Look at the jobs in the SQL Server, and look for the job that has a
scheduled date/time of yesterday.
3. either you call that job or execute the SQL from the only step within
your app. Either way, do not modify the scheduled job or the RS Schedule,
otherwise the link is lost and the report will not work.
If somebody knows how to schedule directly the reports within RS via T-SQL,
please share it with us.
Thank you|||Thats a good tip. Thanks Cesar
--
McGeeky
http://mcgeeky.blogspot.com
"Cesar Meza" <CesarMeza@.discussions.microsoft.com> wrote in message
news:D387E824-1664-4FE0-8FA3-1111DDBBA182@.microsoft.com...
> Try this:
> 1. Schedule the report to send an e-mail the way you want it. Set the next
> run time to yesterday at this time. Save the schedule.
> 2. Look at the jobs in the SQL Server, and look for the job that has a
> scheduled date/time of yesterday.
> 3. either you call that job or execute the SQL from the only step within
> your app. Either way, do not modify the scheduled job or the RS Schedule,
> otherwise the link is lost and the report will not work.
> If somebody knows how to schedule directly the reports within RS via
T-SQL,
> please share it with us.
> Thank you

No comments:

Post a Comment