Monday, March 26, 2012

e-mailing reports and refreshing reports automatically

Hello:
I know that you can e-mail SQL Reporting Services reports. But, can the
reports be configured to refresh their data automatically and be e-mailed to
users automatically with the refreshed data?
Or, would someone have to go into SQL Reporting Services, manually refresh,
and manually e-mail the reports?
Thanks!
childofthe1980sOrdinarily, this is automatic. Unless you tell a report to pull from a
stored snapshot, it is running your queries and re-pulling the data
automatically each time the report is run...
Maybe I misunderstand your question?
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> Hello:
> I know that you can e-mail SQL Reporting Services reports. But, can the
> reports be configured to refresh their data automatically and be e-mailed
> to
> users automatically with the refreshed data?
> Or, would someone have to go into SQL Reporting Services, manually
> refresh,
> and manually e-mail the reports?
> Thanks!
> childofthe1980s|||Well, what I meant is have SQL refresh reports and e-mail the results
automatically behind the scenes without user intervention.
Thanks!
childofthe1980s
"Lisa Slater Nicholls" wrote:
> Ordinarily, this is automatic. Unless you tell a report to pull from a
> stored snapshot, it is running your queries and re-pulling the data
> automatically each time the report is run...
> Maybe I misunderstand your question?
> >L<
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> > Hello:
> >
> > I know that you can e-mail SQL Reporting Services reports. But, can the
> > reports be configured to refresh their data automatically and be e-mailed
> > to
> > users automatically with the refreshed data?
> >
> > Or, would someone have to go into SQL Reporting Services, manually
> > refresh,
> > and manually e-mail the reports?
> >
> > Thanks!
> >
> > childofthe1980s
>|||Then, like I said, this is the way it works <s>. You don't have to
"intervene". Unless you *told* the report to hold a static snapshot, it
*always* pulls the data live, at each subscription run instance.
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:8BDC82B6-1B23-452E-A01A-4730069AEF60@.microsoft.com...
> Well, what I meant is have SQL refresh reports and e-mail the results
> automatically behind the scenes without user intervention.
> Thanks!
> childofthe1980s
> "Lisa Slater Nicholls" wrote:
>> Ordinarily, this is automatic. Unless you tell a report to pull from a
>> stored snapshot, it is running your queries and re-pulling the data
>> automatically each time the report is run...
>> Maybe I misunderstand your question?
>> >L<
>> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
>> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
>> > Hello:
>> >
>> > I know that you can e-mail SQL Reporting Services reports. But, can
>> > the
>> > reports be configured to refresh their data automatically and be
>> > e-mailed
>> > to
>> > users automatically with the refreshed data?
>> >
>> > Or, would someone have to go into SQL Reporting Services, manually
>> > refresh,
>> > and manually e-mail the reports?
>> >
>> > Thanks!
>> >
>> > childofthe1980s
>>

No comments:

Post a Comment