Cache vs Snapshot

I am new to reporting services and have created a few reports. I have
noticed that I can cache or create a snapshot of the reports.
I currently use a Crystal Command line tool to run crystal reports around
4:00 am, and I would like to do the same for some of my reports.
What is the difference and which peroforms faster?
Thanks for your help.I figured it out and thought I would put it here for someone else to learn
from.
A cache is only created when the report is first run, then it can expire
when you want it to. A snapshot runs on your schedule, and stays in history.
I would like a mix, the ability to load the report the first time from the
snapshot, but give the users the ability to run it again with date ranges.
Oh well :)
"John_g" wrote:
> I am new to reporting services and have created a few reports. I have
> noticed that I can cache or create a snapshot of the reports.
> I currently use a Crystal Command line tool to run crystal reports around
> 4:00 am, and I would like to do the same for some of my reports.
> What is the difference and which peroforms faster?
> Thanks for your help.
>|||You could implement this with a report filter. You filter the data after
it's returned, not in the query. If you want to have a cache preloaded, you
can set up a process to call the report with a NULL rendering extension.
That will execute the query without returning the results.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <John_g@.discussions.microsoft.com> wrote in message
news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>I figured it out and thought I would put it here for someone else to learn
> from.
> A cache is only created when the report is first run, then it can expire
> when you want it to. A snapshot runs on your schedule, and stays in
> history.
> I would like a mix, the ability to load the report the first time from the
> snapshot, but give the users the ability to run it again with date ranges.
> Oh well :)
> "John_g" wrote:
>> I am new to reporting services and have created a few reports. I have
>> noticed that I can cache or create a snapshot of the reports.
>> I currently use a Crystal Command line tool to run crystal reports around
>> 4:00 am, and I would like to do the same for some of my reports.
>> What is the difference and which peroforms faster?
>> Thanks for your help.|||Thanks. That sounds like a little more than I currently know how to do.
You are basically saying that I can query the data with a larger date range,
or none at all, cache it, then when the user queries the information, they
are querying the info from the cache?
If so, it this easy, or am I going to have to do some aspx programming?
Thanks for your reply.
"Jeff A. Stucker" wrote:
> You could implement this with a report filter. You filter the data after
> it's returned, not in the query. If you want to have a cache preloaded, you
> can set up a process to call the report with a NULL rendering extension.
> That will execute the query without returning the results.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "John_g" <John_g@.discussions.microsoft.com> wrote in message
> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
> >I figured it out and thought I would put it here for someone else to learn
> > from.
> >
> > A cache is only created when the report is first run, then it can expire
> > when you want it to. A snapshot runs on your schedule, and stays in
> > history.
> >
> > I would like a mix, the ability to load the report the first time from the
> > snapshot, but give the users the ability to run it again with date ranges.
> >
> > Oh well :)
> >
> > "John_g" wrote:
> >
> >> I am new to reporting services and have created a few reports. I have
> >> noticed that I can cache or create a snapshot of the reports.
> >>
> >> I currently use a Crystal Command line tool to run crystal reports around
> >> 4:00 am, and I would like to do the same for some of my reports.
> >>
> >> What is the difference and which peroforms faster?
> >>
> >> Thanks for your help.
> >>
>
>|||Probably not aspx programming. The report filter is just part of the report
design; you can filter groups (check the properties of your List, Table,
Matrix, etc.). To kick off the null report, you may be able to simply
launch a URL using the Windows scheduler. I think the syntax is this:
&rs:Format=NULL
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <Johng@.discussions.microsoft.com> wrote in message
news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
> Thanks. That sounds like a little more than I currently know how to do.
> You are basically saying that I can query the data with a larger date
> range,
> or none at all, cache it, then when the user queries the information, they
> are querying the info from the cache?
> If so, it this easy, or am I going to have to do some aspx programming?
> Thanks for your reply.
>
> "Jeff A. Stucker" wrote:
>> You could implement this with a report filter. You filter the data after
>> it's returned, not in the query. If you want to have a cache preloaded,
>> you
>> can set up a process to call the report with a NULL rendering extension.
>> That will execute the query without returning the results.
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >I figured it out and thought I would put it here for someone else to
>> >learn
>> > from.
>> >
>> > A cache is only created when the report is first run, then it can
>> > expire
>> > when you want it to. A snapshot runs on your schedule, and stays in
>> > history.
>> >
>> > I would like a mix, the ability to load the report the first time from
>> > the
>> > snapshot, but give the users the ability to run it again with date
>> > ranges.
>> >
>> > Oh well :)
>> >
>> > "John_g" wrote:
>> >
>> >> I am new to reporting services and have created a few reports. I have
>> >> noticed that I can cache or create a snapshot of the reports.
>> >>
>> >> I currently use a Crystal Command line tool to run crystal reports
>> >> around
>> >> 4:00 am, and I would like to do the same for some of my reports.
>> >>
>> >> What is the difference and which peroforms faster?
>> >>
>> >> Thanks for your help.
>> >>
>>|||To be more specfiic, launch this programmatically:
http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Probably not aspx programming. The report filter is just part of the
> report design; you can filter groups (check the properties of your List,
> Table, Matrix, etc.). To kick off the null report, you may be able to
> simply launch a URL using the Windows scheduler. I think the syntax is
> this:
> &rs:Format=NULL
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "John_g" <Johng@.discussions.microsoft.com> wrote in message
> news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
>> Thanks. That sounds like a little more than I currently know how to do.
>> You are basically saying that I can query the data with a larger date
>> range,
>> or none at all, cache it, then when the user queries the information,
>> they
>> are querying the info from the cache?
>> If so, it this easy, or am I going to have to do some aspx programming?
>> Thanks for your reply.
>>
>> "Jeff A. Stucker" wrote:
>> You could implement this with a report filter. You filter the data
>> after
>> it's returned, not in the query. If you want to have a cache preloaded,
>> you
>> can set up a process to call the report with a NULL rendering extension.
>> That will execute the query without returning the results.
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >I figured it out and thought I would put it here for someone else to
>> >learn
>> > from.
>> >
>> > A cache is only created when the report is first run, then it can
>> > expire
>> > when you want it to. A snapshot runs on your schedule, and stays in
>> > history.
>> >
>> > I would like a mix, the ability to load the report the first time from
>> > the
>> > snapshot, but give the users the ability to run it again with date
>> > ranges.
>> >
>> > Oh well :)
>> >
>> > "John_g" wrote:
>> >
>> >> I am new to reporting services and have created a few reports. I
>> >> have
>> >> noticed that I can cache or create a snapshot of the reports.
>> >>
>> >> I currently use a Crystal Command line tool to run crystal reports
>> >> around
>> >> 4:00 am, and I would like to do the same for some of my reports.
>> >>
>> >> What is the difference and which peroforms faster?
>> >>
>> >> Thanks for your help.
>> >>
>>
>|||When I run this, what data ranges does it use? My variables are StartDate
and EndDate.
I am just wandering since I am not giving it dates, does it run for all dates?
That could be time consuming.
THanks.
"Jeff A. Stucker" wrote:
> To be more specfiic, launch this programmatically:
> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> > Probably not aspx programming. The report filter is just part of the
> > report design; you can filter groups (check the properties of your List,
> > Table, Matrix, etc.). To kick off the null report, you may be able to
> > simply launch a URL using the Windows scheduler. I think the syntax is
> > this:
> >
> > &rs:Format=NULL
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
> >> Thanks. That sounds like a little more than I currently know how to do.
> >>
> >> You are basically saying that I can query the data with a larger date
> >> range,
> >> or none at all, cache it, then when the user queries the information,
> >> they
> >> are querying the info from the cache?
> >>
> >> If so, it this easy, or am I going to have to do some aspx programming?
> >>
> >> Thanks for your reply.
> >>
> >>
> >> "Jeff A. Stucker" wrote:
> >>
> >> You could implement this with a report filter. You filter the data
> >> after
> >> it's returned, not in the query. If you want to have a cache preloaded,
> >> you
> >> can set up a process to call the report with a NULL rendering extension.
> >> That will execute the query without returning the results.
> >>
> >> --
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
> >> >I figured it out and thought I would put it here for someone else to
> >> >learn
> >> > from.
> >> >
> >> > A cache is only created when the report is first run, then it can
> >> > expire
> >> > when you want it to. A snapshot runs on your schedule, and stays in
> >> > history.
> >> >
> >> > I would like a mix, the ability to load the report the first time from
> >> > the
> >> > snapshot, but give the users the ability to run it again with date
> >> > ranges.
> >> >
> >> > Oh well :)
> >> >
> >> > "John_g" wrote:
> >> >
> >> >> I am new to reporting services and have created a few reports. I
> >> >> have
> >> >> noticed that I can cache or create a snapshot of the reports.
> >> >>
> >> >> I currently use a Crystal Command line tool to run crystal reports
> >> >> around
> >> >> 4:00 am, and I would like to do the same for some of my reports.
> >> >>
> >> >> What is the difference and which peroforms faster?
> >> >>
> >> >> Thanks for your help.
> >> >>
> >>
> >>
> >>
> >
> >
>
>|||It runs for whatever the default dates are specified.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <Johng@.discussions.microsoft.com> wrote in message
news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
> When I run this, what data ranges does it use? My variables are StartDate
> and EndDate.
> I am just wandering since I am not giving it dates, does it run for all
> dates?
> That could be time consuming.
> THanks.
>
> "Jeff A. Stucker" wrote:
>> To be more specfiic, launch this programmatically:
>> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> > Probably not aspx programming. The report filter is just part of the
>> > report design; you can filter groups (check the properties of your
>> > List,
>> > Table, Matrix, etc.). To kick off the null report, you may be able to
>> > simply launch a URL using the Windows scheduler. I think the syntax is
>> > this:
>> >
>> > &rs:Format=NULL
>> >
>> > --
>> > Cheers,
>> >
>> > '(' Jeff A. Stucker
>> > \
>> >
>> > Business Intelligence
>> > www.criadvantage.com
>> > ---
>> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
>> >> Thanks. That sounds like a little more than I currently know how to
>> >> do.
>> >>
>> >> You are basically saying that I can query the data with a larger date
>> >> range,
>> >> or none at all, cache it, then when the user queries the information,
>> >> they
>> >> are querying the info from the cache?
>> >>
>> >> If so, it this easy, or am I going to have to do some aspx
>> >> programming?
>> >>
>> >> Thanks for your reply.
>> >>
>> >>
>> >> "Jeff A. Stucker" wrote:
>> >>
>> >> You could implement this with a report filter. You filter the data
>> >> after
>> >> it's returned, not in the query. If you want to have a cache
>> >> preloaded,
>> >> you
>> >> can set up a process to call the report with a NULL rendering
>> >> extension.
>> >> That will execute the query without returning the results.
>> >>
>> >> --
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >> >I figured it out and thought I would put it here for someone else to
>> >> >learn
>> >> > from.
>> >> >
>> >> > A cache is only created when the report is first run, then it can
>> >> > expire
>> >> > when you want it to. A snapshot runs on your schedule, and stays
>> >> > in
>> >> > history.
>> >> >
>> >> > I would like a mix, the ability to load the report the first time
>> >> > from
>> >> > the
>> >> > snapshot, but give the users the ability to run it again with date
>> >> > ranges.
>> >> >
>> >> > Oh well :)
>> >> >
>> >> > "John_g" wrote:
>> >> >
>> >> >> I am new to reporting services and have created a few reports. I
>> >> >> have
>> >> >> noticed that I can cache or create a snapshot of the reports.
>> >> >>
>> >> >> I currently use a Crystal Command line tool to run crystal reports
>> >> >> around
>> >> >> 4:00 am, and I would like to do the same for some of my reports.
>> >> >>
>> >> >> What is the difference and which peroforms faster?
>> >> >>
>> >> >> Thanks for your help.
>> >> >>
>> >>
>> >>
>> >>
>> >
>> >
>>|||Thanks for your patience. I think I am finally catching on.
I can run the report and leave my variables off of the query, just get the
whole mess. Then I can use parameters and they can be entered by the user at
run-time.
So the cache will simply sit on the server, and when the user hits the query
and passes parms, the report will be run off of the cache, and not directly
hit the SQL Server.
Am I close?
"Jeff A. Stucker" wrote:
> It runs for whatever the default dates are specified.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "John_g" <Johng@.discussions.microsoft.com> wrote in message
> news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
> > When I run this, what data ranges does it use? My variables are StartDate
> > and EndDate.
> >
> > I am just wandering since I am not giving it dates, does it run for all
> > dates?
> > That could be time consuming.
> >
> > THanks.
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> To be more specfiic, launch this programmatically:
> >>
> >> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> > Probably not aspx programming. The report filter is just part of the
> >> > report design; you can filter groups (check the properties of your
> >> > List,
> >> > Table, Matrix, etc.). To kick off the null report, you may be able to
> >> > simply launch a URL using the Windows scheduler. I think the syntax is
> >> > this:
> >> >
> >> > &rs:Format=NULL
> >> >
> >> > --
> >> > Cheers,
> >> >
> >> > '(' Jeff A. Stucker
> >> > \
> >> >
> >> > Business Intelligence
> >> > www.criadvantage.com
> >> > ---
> >> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
> >> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
> >> >> Thanks. That sounds like a little more than I currently know how to
> >> >> do.
> >> >>
> >> >> You are basically saying that I can query the data with a larger date
> >> >> range,
> >> >> or none at all, cache it, then when the user queries the information,
> >> >> they
> >> >> are querying the info from the cache?
> >> >>
> >> >> If so, it this easy, or am I going to have to do some aspx
> >> >> programming?
> >> >>
> >> >> Thanks for your reply.
> >> >>
> >> >>
> >> >> "Jeff A. Stucker" wrote:
> >> >>
> >> >> You could implement this with a report filter. You filter the data
> >> >> after
> >> >> it's returned, not in the query. If you want to have a cache
> >> >> preloaded,
> >> >> you
> >> >> can set up a process to call the report with a NULL rendering
> >> >> extension.
> >> >> That will execute the query without returning the results.
> >> >>
> >> >> --
> >> >> '(' Jeff A. Stucker
> >> >> \
> >> >>
> >> >> Business Intelligence
> >> >> www.criadvantage.com
> >> >> ---
> >> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
> >> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
> >> >> >I figured it out and thought I would put it here for someone else to
> >> >> >learn
> >> >> > from.
> >> >> >
> >> >> > A cache is only created when the report is first run, then it can
> >> >> > expire
> >> >> > when you want it to. A snapshot runs on your schedule, and stays
> >> >> > in
> >> >> > history.
> >> >> >
> >> >> > I would like a mix, the ability to load the report the first time
> >> >> > from
> >> >> > the
> >> >> > snapshot, but give the users the ability to run it again with date
> >> >> > ranges.
> >> >> >
> >> >> > Oh well :)
> >> >> >
> >> >> > "John_g" wrote:
> >> >> >
> >> >> >> I am new to reporting services and have created a few reports. I
> >> >> >> have
> >> >> >> noticed that I can cache or create a snapshot of the reports.
> >> >> >>
> >> >> >> I currently use a Crystal Command line tool to run crystal reports
> >> >> >> around
> >> >> >> 4:00 am, and I would like to do the same for some of my reports.
> >> >> >>
> >> >> >> What is the difference and which peroforms faster?
> >> >> >>
> >> >> >> Thanks for your help.
> >> >> >>
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>|||That's it! Perfect summary.
Since you're running off the cache, and filtering that, then at rendering
time it puts more load on the reporting engine, but zero load on the
back-end database. And that's perfectly fine if the back-end query was
where the thing was bogging down to begin with. So your cache will have a
superset of all the various data your end-users will see on the same report.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <Johng@.discussions.microsoft.com> wrote in message
news:0E1D42DA-702A-41F9-8277-0F5C42B26A5F@.microsoft.com...
> Thanks for your patience. I think I am finally catching on.
> I can run the report and leave my variables off of the query, just get the
> whole mess. Then I can use parameters and they can be entered by the user
> at
> run-time.
> So the cache will simply sit on the server, and when the user hits the
> query
> and passes parms, the report will be run off of the cache, and not
> directly
> hit the SQL Server.
> Am I close?
> "Jeff A. Stucker" wrote:
>> It runs for whatever the default dates are specified.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
>> > When I run this, what data ranges does it use? My variables are
>> > StartDate
>> > and EndDate.
>> >
>> > I am just wandering since I am not giving it dates, does it run for all
>> > dates?
>> > That could be time consuming.
>> >
>> > THanks.
>> >
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> To be more specfiic, launch this programmatically:
>> >>
>> >> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
>> >>
>> >> --
>> >> Cheers,
>> >>
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> >> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> >> > Probably not aspx programming. The report filter is just part of
>> >> > the
>> >> > report design; you can filter groups (check the properties of your
>> >> > List,
>> >> > Table, Matrix, etc.). To kick off the null report, you may be able
>> >> > to
>> >> > simply launch a URL using the Windows scheduler. I think the syntax
>> >> > is
>> >> > this:
>> >> >
>> >> > &rs:Format=NULL
>> >> >
>> >> > --
>> >> > Cheers,
>> >> >
>> >> > '(' Jeff A. Stucker
>> >> > \
>> >> >
>> >> > Business Intelligence
>> >> > www.criadvantage.com
>> >> > ---
>> >> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> >> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
>> >> >> Thanks. That sounds like a little more than I currently know how
>> >> >> to
>> >> >> do.
>> >> >>
>> >> >> You are basically saying that I can query the data with a larger
>> >> >> date
>> >> >> range,
>> >> >> or none at all, cache it, then when the user queries the
>> >> >> information,
>> >> >> they
>> >> >> are querying the info from the cache?
>> >> >>
>> >> >> If so, it this easy, or am I going to have to do some aspx
>> >> >> programming?
>> >> >>
>> >> >> Thanks for your reply.
>> >> >>
>> >> >>
>> >> >> "Jeff A. Stucker" wrote:
>> >> >>
>> >> >> You could implement this with a report filter. You filter the
>> >> >> data
>> >> >> after
>> >> >> it's returned, not in the query. If you want to have a cache
>> >> >> preloaded,
>> >> >> you
>> >> >> can set up a process to call the report with a NULL rendering
>> >> >> extension.
>> >> >> That will execute the query without returning the results.
>> >> >>
>> >> >> --
>> >> >> '(' Jeff A. Stucker
>> >> >> \
>> >> >>
>> >> >> Business Intelligence
>> >> >> www.criadvantage.com
>> >> >> ---
>> >> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> >> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >> >> >I figured it out and thought I would put it here for someone else
>> >> >> >to
>> >> >> >learn
>> >> >> > from.
>> >> >> >
>> >> >> > A cache is only created when the report is first run, then it
>> >> >> > can
>> >> >> > expire
>> >> >> > when you want it to. A snapshot runs on your schedule, and
>> >> >> > stays
>> >> >> > in
>> >> >> > history.
>> >> >> >
>> >> >> > I would like a mix, the ability to load the report the first
>> >> >> > time
>> >> >> > from
>> >> >> > the
>> >> >> > snapshot, but give the users the ability to run it again with
>> >> >> > date
>> >> >> > ranges.
>> >> >> >
>> >> >> > Oh well :)
>> >> >> >
>> >> >> > "John_g" wrote:
>> >> >> >
>> >> >> >> I am new to reporting services and have created a few reports.
>> >> >> >> I
>> >> >> >> have
>> >> >> >> noticed that I can cache or create a snapshot of the reports.
>> >> >> >>
>> >> >> >> I currently use a Crystal Command line tool to run crystal
>> >> >> >> reports
>> >> >> >> around
>> >> >> >> 4:00 am, and I would like to do the same for some of my
>> >> >> >> reports.
>> >> >> >>
>> >> >> >> What is the difference and which peroforms faster?
>> >> >> >>
>> >> >> >> Thanks for your help.
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||Thanks Jeff! I truly appreciate your help.
One last question... I did as you said, but I cannot get my date to
filter. The date field is datetime, but when I try '10/1/2004' or without
the quotes, or even add time, it says that the data is not comparable.
Also, I have been having a hard time scheduling the null report, but I have
not given up yet.
Thanks again
"Jeff A. Stucker" wrote:
> That's it! Perfect summary.
> Since you're running off the cache, and filtering that, then at rendering
> time it puts more load on the reporting engine, but zero load on the
> back-end database. And that's perfectly fine if the back-end query was
> where the thing was bogging down to begin with. So your cache will have a
> superset of all the various data your end-users will see on the same report.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "John_g" <Johng@.discussions.microsoft.com> wrote in message
> news:0E1D42DA-702A-41F9-8277-0F5C42B26A5F@.microsoft.com...
> > Thanks for your patience. I think I am finally catching on.
> >
> > I can run the report and leave my variables off of the query, just get the
> > whole mess. Then I can use parameters and they can be entered by the user
> > at
> > run-time.
> >
> > So the cache will simply sit on the server, and when the user hits the
> > query
> > and passes parms, the report will be run off of the cache, and not
> > directly
> > hit the SQL Server.
> >
> > Am I close?
> >
> > "Jeff A. Stucker" wrote:
> >
> >> It runs for whatever the default dates are specified.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "John_g" <Johng@.discussions.microsoft.com> wrote in message
> >> news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
> >> > When I run this, what data ranges does it use? My variables are
> >> > StartDate
> >> > and EndDate.
> >> >
> >> > I am just wandering since I am not giving it dates, does it run for all
> >> > dates?
> >> > That could be time consuming.
> >> >
> >> > THanks.
> >> >
> >> >
> >> > "Jeff A. Stucker" wrote:
> >> >
> >> >> To be more specfiic, launch this programmatically:
> >> >>
> >> >> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
> >> >>
> >> >> --
> >> >> Cheers,
> >> >>
> >> >> '(' Jeff A. Stucker
> >> >> \
> >> >>
> >> >> Business Intelligence
> >> >> www.criadvantage.com
> >> >> ---
> >> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> >> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> >> > Probably not aspx programming. The report filter is just part of
> >> >> > the
> >> >> > report design; you can filter groups (check the properties of your
> >> >> > List,
> >> >> > Table, Matrix, etc.). To kick off the null report, you may be able
> >> >> > to
> >> >> > simply launch a URL using the Windows scheduler. I think the syntax
> >> >> > is
> >> >> > this:
> >> >> >
> >> >> > &rs:Format=NULL
> >> >> >
> >> >> > --
> >> >> > Cheers,
> >> >> >
> >> >> > '(' Jeff A. Stucker
> >> >> > \
> >> >> >
> >> >> > Business Intelligence
> >> >> > www.criadvantage.com
> >> >> > ---
> >> >> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
> >> >> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
> >> >> >> Thanks. That sounds like a little more than I currently know how
> >> >> >> to
> >> >> >> do.
> >> >> >>
> >> >> >> You are basically saying that I can query the data with a larger
> >> >> >> date
> >> >> >> range,
> >> >> >> or none at all, cache it, then when the user queries the
> >> >> >> information,
> >> >> >> they
> >> >> >> are querying the info from the cache?
> >> >> >>
> >> >> >> If so, it this easy, or am I going to have to do some aspx
> >> >> >> programming?
> >> >> >>
> >> >> >> Thanks for your reply.
> >> >> >>
> >> >> >>
> >> >> >> "Jeff A. Stucker" wrote:
> >> >> >>
> >> >> >> You could implement this with a report filter. You filter the
> >> >> >> data
> >> >> >> after
> >> >> >> it's returned, not in the query. If you want to have a cache
> >> >> >> preloaded,
> >> >> >> you
> >> >> >> can set up a process to call the report with a NULL rendering
> >> >> >> extension.
> >> >> >> That will execute the query without returning the results.
> >> >> >>
> >> >> >> --
> >> >> >> '(' Jeff A. Stucker
> >> >> >> \
> >> >> >>
> >> >> >> Business Intelligence
> >> >> >> www.criadvantage.com
> >> >> >> ---
> >> >> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
> >> >> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
> >> >> >> >I figured it out and thought I would put it here for someone else
> >> >> >> >to
> >> >> >> >learn
> >> >> >> > from.
> >> >> >> >
> >> >> >> > A cache is only created when the report is first run, then it
> >> >> >> > can
> >> >> >> > expire
> >> >> >> > when you want it to. A snapshot runs on your schedule, and
> >> >> >> > stays
> >> >> >> > in
> >> >> >> > history.
> >> >> >> >
> >> >> >> > I would like a mix, the ability to load the report the first
> >> >> >> > time
> >> >> >> > from
> >> >> >> > the
> >> >> >> > snapshot, but give the users the ability to run it again with
> >> >> >> > date
> >> >> >> > ranges.
> >> >> >> >
> >> >> >> > Oh well :)
> >> >> >> >
> >> >> >> > "John_g" wrote:
> >> >> >> >
> >> >> >> >> I am new to reporting services and have created a few reports.
> >> >> >> >> I
> >> >> >> >> have
> >> >> >> >> noticed that I can cache or create a snapshot of the reports.
> >> >> >> >>
> >> >> >> >> I currently use a Crystal Command line tool to run crystal
> >> >> >> >> reports
> >> >> >> >> around
> >> >> >> >> 4:00 am, and I would like to do the same for some of my
> >> >> >> >> reports.
> >> >> >> >>
> >> >> >> >> What is the difference and which peroforms faster?
> >> >> >> >>
> >> >> >> >> Thanks for your help.
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Where is your filter set up and what's it look like where the date is
bombing?
Have you verified that the null report works by calling the URL directly
from a browser? I'm not an expert on scheduling, so perhaps someone else
can help you with that.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <Johng@.discussions.microsoft.com> wrote in message
news:CA494272-DC24-49CD-9FB7-70852295EDD8@.microsoft.com...
> Thanks Jeff! I truly appreciate your help.
> One last question... I did as you said, but I cannot get my date to
> filter. The date field is datetime, but when I try '10/1/2004' or without
> the quotes, or even add time, it says that the data is not comparable.
> Also, I have been having a hard time scheduling the null report, but I
> have
> not given up yet.
> Thanks again
> "Jeff A. Stucker" wrote:
>> That's it! Perfect summary.
>> Since you're running off the cache, and filtering that, then at rendering
>> time it puts more load on the reporting engine, but zero load on the
>> back-end database. And that's perfectly fine if the back-end query was
>> where the thing was bogging down to begin with. So your cache will have
>> a
>> superset of all the various data your end-users will see on the same
>> report.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> news:0E1D42DA-702A-41F9-8277-0F5C42B26A5F@.microsoft.com...
>> > Thanks for your patience. I think I am finally catching on.
>> >
>> > I can run the report and leave my variables off of the query, just get
>> > the
>> > whole mess. Then I can use parameters and they can be entered by the
>> > user
>> > at
>> > run-time.
>> >
>> > So the cache will simply sit on the server, and when the user hits the
>> > query
>> > and passes parms, the report will be run off of the cache, and not
>> > directly
>> > hit the SQL Server.
>> >
>> > Am I close?
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> It runs for whatever the default dates are specified.
>> >>
>> >> --
>> >> Cheers,
>> >>
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> >> news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
>> >> > When I run this, what data ranges does it use? My variables are
>> >> > StartDate
>> >> > and EndDate.
>> >> >
>> >> > I am just wandering since I am not giving it dates, does it run for
>> >> > all
>> >> > dates?
>> >> > That could be time consuming.
>> >> >
>> >> > THanks.
>> >> >
>> >> >
>> >> > "Jeff A. Stucker" wrote:
>> >> >
>> >> >> To be more specfiic, launch this programmatically:
>> >> >>
>> >> >> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
>> >> >>
>> >> >> --
>> >> >> Cheers,
>> >> >>
>> >> >> '(' Jeff A. Stucker
>> >> >> \
>> >> >>
>> >> >> Business Intelligence
>> >> >> www.criadvantage.com
>> >> >> ---
>> >> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> >> >> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> >> >> > Probably not aspx programming. The report filter is just part of
>> >> >> > the
>> >> >> > report design; you can filter groups (check the properties of
>> >> >> > your
>> >> >> > List,
>> >> >> > Table, Matrix, etc.). To kick off the null report, you may be
>> >> >> > able
>> >> >> > to
>> >> >> > simply launch a URL using the Windows scheduler. I think the
>> >> >> > syntax
>> >> >> > is
>> >> >> > this:
>> >> >> >
>> >> >> > &rs:Format=NULL
>> >> >> >
>> >> >> > --
>> >> >> > Cheers,
>> >> >> >
>> >> >> > '(' Jeff A. Stucker
>> >> >> > \
>> >> >> >
>> >> >> > Business Intelligence
>> >> >> > www.criadvantage.com
>> >> >> > ---
>> >> >> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> >> >> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
>> >> >> >> Thanks. That sounds like a little more than I currently know
>> >> >> >> how
>> >> >> >> to
>> >> >> >> do.
>> >> >> >>
>> >> >> >> You are basically saying that I can query the data with a larger
>> >> >> >> date
>> >> >> >> range,
>> >> >> >> or none at all, cache it, then when the user queries the
>> >> >> >> information,
>> >> >> >> they
>> >> >> >> are querying the info from the cache?
>> >> >> >>
>> >> >> >> If so, it this easy, or am I going to have to do some aspx
>> >> >> >> programming?
>> >> >> >>
>> >> >> >> Thanks for your reply.
>> >> >> >>
>> >> >> >>
>> >> >> >> "Jeff A. Stucker" wrote:
>> >> >> >>
>> >> >> >> You could implement this with a report filter. You filter the
>> >> >> >> data
>> >> >> >> after
>> >> >> >> it's returned, not in the query. If you want to have a cache
>> >> >> >> preloaded,
>> >> >> >> you
>> >> >> >> can set up a process to call the report with a NULL rendering
>> >> >> >> extension.
>> >> >> >> That will execute the query without returning the results.
>> >> >> >>
>> >> >> >> --
>> >> >> >> '(' Jeff A. Stucker
>> >> >> >> \
>> >> >> >>
>> >> >> >> Business Intelligence
>> >> >> >> www.criadvantage.com
>> >> >> >> ---
>> >> >> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> >> >> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >> >> >> >I figured it out and thought I would put it here for someone
>> >> >> >> >else
>> >> >> >> >to
>> >> >> >> >learn
>> >> >> >> > from.
>> >> >> >> >
>> >> >> >> > A cache is only created when the report is first run, then it
>> >> >> >> > can
>> >> >> >> > expire
>> >> >> >> > when you want it to. A snapshot runs on your schedule, and
>> >> >> >> > stays
>> >> >> >> > in
>> >> >> >> > history.
>> >> >> >> >
>> >> >> >> > I would like a mix, the ability to load the report the first
>> >> >> >> > time
>> >> >> >> > from
>> >> >> >> > the
>> >> >> >> > snapshot, but give the users the ability to run it again with
>> >> >> >> > date
>> >> >> >> > ranges.
>> >> >> >> >
>> >> >> >> > Oh well :)
>> >> >> >> >
>> >> >> >> > "John_g" wrote:
>> >> >> >> >
>> >> >> >> >> I am new to reporting services and have created a few
>> >> >> >> >> reports.
>> >> >> >> >> I
>> >> >> >> >> have
>> >> >> >> >> noticed that I can cache or create a snapshot of the
>> >> >> >> >> reports.
>> >> >> >> >>
>> >> >> >> >> I currently use a Crystal Command line tool to run crystal
>> >> >> >> >> reports
>> >> >> >> >> around
>> >> >> >> >> 4:00 am, and I would like to do the same for some of my
>> >> >> >> >> reports.
>> >> >> >> >>
>> >> >> >> >> What is the difference and which peroforms faster?
>> >> >> >> >>
>> >> >> >> >> Thanks for your help.
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>