Friday, March 30, 2012

scheduling reports to refresh

Hi all!
Is it possible to schedule reports to refresh overnight? Particularly if
they take a long time to return data - for example in business objects i
would normally schedule a report to refresh overnight via the broadcast
agent console...is the same thing at all possible in reporting services?
does RS have sheduling functionality?
many thanks
GregYes, it has extensive functionality in this area.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
> Hi all!
> Is it possible to schedule reports to refresh overnight? Particularly if
> they take a long time to return data - for example in business objects i
> would normally schedule a report to refresh overnight via the broadcast
> agent console...is the same thing at all possible in reporting services?
> does RS have sheduling functionality?
> many thanks
> Greg|||ok.....anything further? lol
HOW DO I DO IT!!!
anyone'
"Bruce L-C [MVP]" wrote:
> Yes, it has extensive functionality in this area.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
> > Hi all!
> >
> > Is it possible to schedule reports to refresh overnight? Particularly if
> > they take a long time to return data - for example in business objects i
> > would normally schedule a report to refresh overnight via the broadcast
> > agent console...is the same thing at all possible in reporting services?
> > does RS have sheduling functionality?
> >
> > many thanks
> >
> > Greg
>
>|||It seemed like you just wondered if it was possible. I thought that maybe
you weren't using Reporting Services and were just making plans.
Anyway, a few of what you need to understand. Search in books online for
snapshot, schedule and history. Reading up on those things should get you
started. Here are a few links to get you rolling:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsmain/htm/rsc_ov_using_v1_4u43.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_catalog_v1_9zsm.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_scheduling_v1_2qgk.asp
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:593EBCB8-9CA6-42BB-994C-CFAB8F44495F@.microsoft.com...
> ok.....anything further? lol
> HOW DO I DO IT!!!
> anyone'
> "Bruce L-C [MVP]" wrote:
>> Yes, it has extensive functionality in this area.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Greg" <Greg@.discussions.microsoft.com> wrote in message
>> news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
>> > Hi all!
>> >
>> > Is it possible to schedule reports to refresh overnight? Particularly
>> > if
>> > they take a long time to return data - for example in business objects
>> > i
>> > would normally schedule a report to refresh overnight via the
>> > broadcast
>> > agent console...is the same thing at all possible in reporting
>> > services?
>> > does RS have sheduling functionality?
>> >
>> > many thanks
>> >
>> > Greg
>>

No comments:

Post a Comment