Learn how to Schedule your Sage BI Reports automatically - Aptus Business Solutions
Aptus Business Solutions specialise in delivery and supporting solutions for Sage X3, Sage 300, Sage CRM and Sage Intacct. With over 30 years of knowledge, we have been supporting clients from around Australia and internationally. We cater to businesses of all sizes and business areas. Our services, support and business systems understanding enable clients to succeed and grow in their industry. We cover all aspects of system design, business processes, consultancy, hosting and IT, development and systems integration.
ERP, Consultants, Sage, Finance Management, Accounts Management, Sage 300, Sage X3, Sage Intacct, Sage Enterprise Manager, Sage CRM, Finance software, Accounts software, Business Solutions, Business Systems
16006
post-template-default,single,single-post,postid-16006,single-format-standard,ajax_fade,page_not_loaded,,side_area_uncovered_from_content,transparent_content,qode-child-theme-ver-1.0.0,qode-theme-ver-16.7,qode-theme-bridge,wpb-js-composer js-comp-ver-5.5.2,vc_responsive

Learn how to Schedule your Sage BI Reports automatically

Learn how to Schedule your Sage BI Reports automatically

Stop manually distributing your reports and start saving time by scheduling your reports to automatically distribute. In this tip, we’ll show you how to quickly set up your automatic report distribution with your existing Sage Intelligence Report Manager and your Windows Task Scheduler.

This process is made up of 3 easy steps:

1. Decide where you’re going to save your report.
2. Create the Scheduler Command.
3. Set up the Windows Scheduler Task.

It’s important to remember that the workstation where you create the scheduled task,
must be turned ON at the scheduled time.

Also, when using the Task Scheduler, your user name must be a valid account on the
domain or your local machine, with sufficient privileges to run the reports. You must also
have sufficient permissions to access all the necessary resources to run the reports.

Step 1: Decide where you’re going to save your report

1. In the Report Manager window, select the report you’re going to distribute.
2. Then, in the Properties window, tick the Show Advanced box found at the bottom of
the window.
3. Click the Generate Output File ellipsis button and browse to the location you want the
report to be saved to when it runs out.

Step 2: Create the Scheduler Command

  1. From the Object window, right-click on your report, then select Generate Scheduler Command.
    1. If the report expects parameters, you will be prompted to enter them before continuing.When you’re done, a message box display’s and you’ll see that it shows the syntax for running the report. Don’t worry about trying to copy the syntax from this message, because it has been simultaneously placed in the Windows clipboard, so that you can paste it into the Scheduler Task Command field.

Step 3: Set up the Windows Scheduler Task

  1. Next, open the Windows Task Scheduler.
  2. From the Action drop down menu, select Create Task.

The Create Task window displays

3. In the Name field, give your task a meaningful name. For example, Current Period Income Statement

4. Then click on the Triggers tab and select New.

5. You can schedule your report run on a specific day, at a specific time and you can also
set it to stop running on a specific day. Go through the options and find the ones that
would best suit your needs. When completed click OK.

6. Now, click on the Actions tab and select New.
7. In the Program/script field, paste the command from your clipboard and then click OK.

8. Click YES to confirm and continue.

9. Now, click on the Settings tab and set up your Task Schedule options

10.Then click OK.
11. The report you chose to run via the schedule, will now appear as an Active Task in Task
Scheduler.

Contact us at support@aptusbusiness.com.au for further information.