Need Help: How to schedule a report that has parameter?
-
Hi All:
I have created a report that is based on stored procedure and also has some parameters. Manually after entering proper parameter values, I can run the report properly.
My questions are:
1. How can I schedule this report?
2. While scheduling this report, is there anyway I can provide the corresponding proper parameter values so that I can get my required report?
I would appreciate your help.
Thanks.
Sam
-
Q1. Click the "New Subscription" icon for your report and you'll be presented with a page that will enable you to schedule execution and choose a delivery method and format. (Snapshot of a typical report page with the icon is hopefully shown below - if not, just look on the toobar beneath the four tabs at the top left of the Report Manager page.)
Q2. The page you get to enables you to set explicit parameter values that are stored with the subscription and used each time the Report is run for the subscription.
Additional Info:
Take a look at the top-right of the Report Manager page and click the "Site Settings" link. The page you get to has anothe link, "Manage shared schedules" at the lower-left, under the "Other" heading. You can set up as many predefined schedules as you need, then, for your report subscription, choose one of them so you don't need to define the same schedule repeatedly.
Hope this helps.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply