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.

Schedule task DB connection

I need to know how to pass parameters that could tell an executable through the task scheduler, to initiate the ODBC connection first and execute the executable. I do not want to leave a PC, server, terminal server session or similar mechanism running and logged into DB prior to the scheduled task running. This keeps the ODBC connection initialized and available for the Import executable to use when it runs (as a scheduled task). However, that will not be a reliable, long term solution for automating the import as the session would be killed if the server is rebooted, somebody may accidentally close it or a number of other scenarios could cause it to get closed.

Question How do you make the ODBC connection to the database when running the schedule task function, prior to the software executable running. I am using the scheduled function to automactically excute a xml import every 10 minutes. My software keeps stating no db connection. I have looked everywhere and can not find how to tell in this schedule task function command line how to connect to the DB prior to running the process. Does any one know how to fully automating the connection to a ODBC prior to running the executable.

thanks techbk

Are you using any SQL Server tools here?

Schedule report with parameters

I need to schedule a report to run multiple times with a different value for its one input parameter each time. Can this be done?Data Driven Subscription should do the trick. It is available with the Enterprise Edition of SQL Server

Schedule report delivery for all parameters

Is it possible to schedule the delivery of a report (to a file share
say) for each possible value of a parameter?
So, if I have a report that accepts a value for parameter @.color and
shows the corresponding tshirts in that color, and there are 3 possible
values for @.color (red, green, blue), can I somehow schedule the report
to automatically run for each value (resulting in 3 delivered reports)?
Thanks!You want to look into DataDriven Subscriptions. These allow you to execute
a query and use the results to drive subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1108132927.922517.3740@.l41g2000cwc.googlegroups.com...
> Is it possible to schedule the delivery of a report (to a file share
> say) for each possible value of a parameter?
> So, if I have a report that accepts a value for parameter @.color and
> shows the corresponding tshirts in that color, and there are 3 possible
> values for @.color (red, green, blue), can I somehow schedule the report
> to automatically run for each value (resulting in 3 delivered reports)?
> Thanks!
>

Schedule a report to run at a particular time with user filled parameters

I have a report that I would like to run in the evening due to high database usage that required a user to fill in selected parameters. Is there anyway to allow a user to fill in the report parameters and have it scheduled to run at 3:00 AM.

Thanks,

Chris

You could use a data driven subscription, which relies on a table you create to store the parameters for the report. Then provide the user with a simple interface to set the parameters in the table.

Or you could let them create a linked report in their My Reports folder, and set up their own subscription from there, which allows them to specify parameters values.

|||Would you mind elaborating on this technique, or pass along some documentation/samples for this? I am most interested in how you setup this 'table' that stores the parameters for the report and of course how you configure the report to use the values in the table.

Thanks!|||

I never did find a great solution to this problem. Please let me know if you do find one.

Thanks,

|||

What part of the solutions that you were offered didn't you like? I thought they were both good, depending on business requirements, and I wasn't too sure from what you described which one would meet yours... but didn't expect to hear that you used neither <s>.

So... what was the issue in your case?

>L<

PS. You can also roll your own. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2022350&SiteID=1. But I'm not (yet) convinced you need to, in your case...

|||Neither of the above options worked for you?

Schedule a report to run at a particular time with user filled parameters

I have a report that I would like to run in the evening due to high database usage that required a user to fill in selected parameters. Is there anyway to allow a user to fill in the report parameters and have it scheduled to run at 3:00 AM.

Thanks,

Chris

You could use a data driven subscription, which relies on a table you create to store the parameters for the report. Then provide the user with a simple interface to set the parameters in the table.

Or you could let them create a linked report in their My Reports folder, and set up their own subscription from there, which allows them to specify parameters values.

|||Would you mind elaborating on this technique, or pass along some documentation/samples for this? I am most interested in how you setup this 'table' that stores the parameters for the report and of course how you configure the report to use the values in the table.

Thanks!
|||

I never did find a great solution to this problem. Please let me know if you do find one.

Thanks,

|||

What part of the solutions that you were offered didn't you like? I thought they were both good, depending on business requirements, and I wasn't too sure from what you described which one would meet yours... but didn't expect to hear that you used neither <s>.

So... what was the issue in your case?

>L<

PS. You can also roll your own. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2022350&SiteID=1. But I'm not (yet) convinced you need to, in your case...

|||Neither of the above options worked for you?

Schedule a report to run at a particular time with user filled parameters

I have a report that I would like to run in the evening due to high database usage that required a user to fill in selected parameters. Is there anyway to allow a user to fill in the report parameters and have it scheduled to run at 3:00 AM.

Thanks,

Chris

You could use a data driven subscription, which relies on a table you create to store the parameters for the report. Then provide the user with a simple interface to set the parameters in the table.

Or you could let them create a linked report in their My Reports folder, and set up their own subscription from there, which allows them to specify parameters values.

|||Would you mind elaborating on this technique, or pass along some documentation/samples for this? I am most interested in how you setup this 'table' that stores the parameters for the report and of course how you configure the report to use the values in the table.

Thanks!
|||

I never did find a great solution to this problem. Please let me know if you do find one.

Thanks,

|||

What part of the solutions that you were offered didn't you like? I thought they were both good, depending on business requirements, and I wasn't too sure from what you described which one would meet yours... but didn't expect to hear that you used neither <s>.

So... what was the issue in your case?

>L<

PS. You can also roll your own. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2022350&SiteID=1. But I'm not (yet) convinced you need to, in your case...

|||Neither of the above options worked for you?