Event Driven Info

I need to gather as much information as I can about event driven reports for
both 2000 and 2005 versions of reporting services. I have a huge reporting
project that involves 23 site company. So that means 23 databases (Oracle on
top of it all) working off of one Sql Server box. It can be done but I do not
know much about event-driven reports and I was wondering if anyone knew of
some articles I could read or any information really would be great.
Thanks in advance and Have a great day,
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200601/1If you're looking to do event driven reporting on that scale, I'd start
by looking at SQL Notification Services.
http://msdn.microsoft.com/sql/bi/notification/
Andy Potter|||Thank you for responding. I had a chance to look into what you suggested, a
little. I am still not sure if that is what I need. The question that was
asked was if the report could be ran and delivered after a batch job was done
correctly. Meaning, the end of Month Batch was ran for the general ledger and
after all the data was rolled up into the correct tables can you have some
kind of trigger to run a report and then have it sent to whoever. I am not
very good at explaining things, sorry.
Thanks in advanced
Potter wrote:
>If you're looking to do event driven reporting on that scale, I'd start
>by looking at SQL Notification Services.
>http://msdn.microsoft.com/sql/bi/notification/
>Andy Potter
--
Message posted via http://www.sqlmonster.com|||Yes. I pointed you to Notification Services because you made it sound
like your reporting project was more complex and on a larger scale.
Reporting Services features report Subscriptions that can handle most
'monthly batch reporting' needs.
Andy Potter|||That is the conclusion I was coming to also. After reading what I did about
Nofication Services we will benefit from using it also. So you killed two
birds with one stone for me. Thank you for the confirmation!!!!!
Potter wrote:
>Yes. I pointed you to Notification Services because you made it sound
>like your reporting project was more complex and on a larger scale.
>Reporting Services features report Subscriptions that can handle most
>'monthly batch reporting' needs.
>Andy Potter
--
Message posted via http://www.sqlmonster.com