Sunday, April 6, 2014

How to define more than one schedule for a report

There are two different methods to run a report at different scheduled times.

          
                    create a separate job for the report. For example, to have 'report01' report to run at 2 different schedules, create 2 jobs containing the same report and set the schedule for the jobs accordingly. So each job will be associated to the same report but will have a different schedule.

         create a Report View for the report, and set a schedule for the report view object. Report Views are similar to shortcuts in that they refer to the original report. Thus, if the design of the original report changes, the Report View doesn't need to be modified. And, because the Report View is a distinct object, it can have its own set of schedules and run options. Note that if the original report is moved, the Report View will need also to be updated to reflect the new location.

No comments:

Post a Comment