Showing posts with label refresh. Show all posts
Showing posts with label refresh. Show all posts

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
>>

Wednesday, March 7, 2012

EM slows windows

Often, EM running on my desktop will cause all other
windows either to refresh very slowly or not at all. (I
may get a border with some of the display) I can't
navigate to any window completely until I shut down EM.
SQL 2000 running on Win2k.
Thanks.
One possibility is that you have ODBC tracing turned on. You
can check by going to Administrative Tools and then to the
ODBC Data Source Administrator. Click on the Tracing tab. If
caption on the command button says "Stop Tracing Now", click
that button. That will turn off ODBC tracing.
-Sue
On Wed, 9 Jun 2004 07:08:54 -0700, "Andy Mous"
<andymous@.discussions.microsoft.com> wrote:

>Often, EM running on my desktop will cause all other
>windows either to refresh very slowly or not at all. (I
>may get a border with some of the display) I can't
>navigate to any window completely until I shut down EM.
>SQL 2000 running on Win2k.
>Thanks.