Scheduled report w/ Parameters

I have a sproc w/ 3 parameters. I'd like the schedule to kick in and
run through a list that would contain the parametes, I'm guessing this
won't work this way in Reporting services, but rather I'd have to
schedule x number of reports... is that right?
say for example Terretory 1 for Startdate 6/1/2004 EndDate 6/30/2004
then repeat that criteria for Territory 2-29
next month the dates should auto-cycle to 7/1/2004 - 7/31/2004.
Thanks for any tips or pointers :DYou can use data driven subsciption:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_subscribing_v1_7oj9.asp
Check also this walkthrough
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_tutorials_v1_59ye.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Francisco H Tapia" <fhtapia@.hotmail.com> wrote in message
news:%23doGqsBdEHA.644@.tk2msftngp13.phx.gbl...
>I have a sproc w/ 3 parameters. I'd like the schedule to kick in and run
>through a list that would contain the parametes, I'm guessing this won't
>work this way in Reporting services, but rather I'd have to schedule x
>number of reports... is that right?
>
> say for example Terretory 1 for Startdate 6/1/2004 EndDate 6/30/2004
> then repeat that criteria for Territory 2-29
> next month the dates should auto-cycle to 7/1/2004 - 7/31/2004.
>
> Thanks for any tips or pointers :D|||Well, you should do the following:
1) Set the date parameters to have expression based default values that
calculate based on the current date and generate the appropriate date range.
2) configure a data driven subscrpiption to the retrieves the correct set of
territories from a database
3) schedule the D-D sub to run monthly.
With this approach you'll need to save the rendered report somewhere and you
won't have snapshots on the server.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Francisco H Tapia" <fhtapia@.hotmail.com> wrote in message
news:%23doGqsBdEHA.644@.tk2msftngp13.phx.gbl...
>I have a sproc w/ 3 parameters. I'd like the schedule to kick in and run
>through a list that would contain the parametes, I'm guessing this won't
>work this way in Reporting services, but rather I'd have to schedule x
>number of reports... is that right?
>
> say for example Terretory 1 for Startdate 6/1/2004 EndDate 6/30/2004
> then repeat that criteria for Territory 2-29
> next month the dates should auto-cycle to 7/1/2004 - 7/31/2004.
>
> Thanks for any tips or pointers :D|||Lev Semenets [MSFT] wrote On 7/27/2004 3:53 PM:
> You can use data driven subsciption:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_subscribing_v1_7oj9.asp
> Check also this walkthrough
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_tutorials_v1_59ye.asp
>
thanks for the links :D|||Lukasz Pawlowski [MSFT] wrote On 7/27/2004 3:54 PM:
> Well, you should do the following:
> 1) Set the date parameters to have expression based default values that
> calculate based on the current date and generate the appropriate date range.
> 2) configure a data driven subscrpiption to the retrieves the correct set of
> territories from a database
> 3) schedule the D-D sub to run monthly.
> With this approach you'll need to save the rendered report somewhere and you
> won't have snapshots on the server.
> -Lukasz
>
This gives me more to go on, thanks for helping me.