How To Run the report on a schedule and save as .html

Rather than have the SQL Server hit many times during the day when
people look at the report,
I was wondering how to run the report once, at night, and save the
output as html
Then, when users look at the report during the day, they see the
static results of the over night run.
Faster response, less load on the SQL Server.
Perhaps it is already there and I just need the current vocabulary.
IanOyou have 2 options
schedule and delivery (like sending an email with the report as PDf or HTML)
report snapshot (the report is generated 1 time and RS keep the result and
display the latest snapshot instead of reading the database again)
hit the subscription or history button when you are in a report in report
server (http://localhost/reports)
"IanO" <IanONet@.gmail.com> wrote in message
news:1178673504.082329.323830@.h2g2000hsg.googlegroups.com...
> Rather than have the SQL Server hit many times during the day when
> people look at the report,
> I was wondering how to run the report once, at night, and save the
> output as html
> Then, when users look at the report during the day, they see the
> static results of the over night run.
> Faster response, less load on the SQL Server.
> Perhaps it is already there and I just need the current vocabulary.
> IanO
>|||Apart from these two options there is one more called "Null Delivery"
basically it is used for running the report first and keeping in the cache.
so next time it access from the cache, ofcourse you dont change anything.. so
this will be a faster method since it keeps it in the cache. But watch out
for ways cache expires.
Amarnath
"Jeje" wrote:
> you have 2 options
> schedule and delivery (like sending an email with the report as PDf or HTML)
> report snapshot (the report is generated 1 time and RS keep the result and
> display the latest snapshot instead of reading the database again)
> hit the subscription or history button when you are in a report in report
> server (http://localhost/reports)
>
> "IanO" <IanONet@.gmail.com> wrote in message
> news:1178673504.082329.323830@.h2g2000hsg.googlegroups.com...
> > Rather than have the SQL Server hit many times during the day when
> > people look at the report,
> > I was wondering how to run the report once, at night, and save the
> > output as html
> >
> > Then, when users look at the report during the day, they see the
> > static results of the over night run.
> > Faster response, less load on the SQL Server.
> >
> > Perhaps it is already there and I just need the current vocabulary.
> >
> > IanO
> >
>sql