How can we help?

Using Windows Task Scheduler to execute reports

You are here:
Go Back

Setup DSStudio Reports to execute with Windows Task Scheduler

Depending upon the report parameter requirements you can schedule DSStudio Reports to run on a specific schedule.  Once you setup the Task Scheduler your report or export will execute unattended for the time frame you set.

Let’s walk through creating our Sage 50 Audit Report to generate every day at 11:00 pm.

First, we need to get some information about the DSStudio Viewer and the DSStudio Report we want to execute.

Open DSStudio Viewer and find your report.  Click on the Options button in the lower right corner of the report.

DSStudio get report information

NC2 Next click the Report Settings option.

DSStudio Report Settings Screen

On the bottom of the screen, you will see two pieces of information that we need.  The EXE Info and the File Name.  Both of these areas will allow you to use <Ctrl> a (select all) and <Ctrl> c to copy them.  Lets first click the EXE Info area and press <Ctrl> a then <Ctrl> c.  Keep this window open as we will later need to do get the Filename.

DSStudio Report File Name Screen

NC3 We now need to start the Windows Task Scheduler.  This can be done in multiple ways.  One way is to press the Windows Key and enter Task Scheduler into the Search Box and select Task Scheduler.

Windows Task Scheduler Basic Screen

NC4 First, click on the Task Scheduler Library on the left to highlight it.  Then select Create Basic Task… on the right of the screen.

Windows Task Scheduler Page 1

NC5 The above is only an example.  Depending upon what report you want to execute please change the fields above.

Click Next > to go to the next

Windows Task Scheduler Page 2

NC6 For our example, we are going to run this report Daily.
Click Next > to go to the next screen.

Windows Task Scheduler Page 3

NC7 In our example we want the report to run every day at 11:00 pm.  Complete this screen and Click Next > to go to the next screen.

Windows Task Schedule Page 4

NC8 Nothing needed to change on the screen above.  Click Next > to go to the next screen.

Windows Task Scheduler Page 5

Here is where we need our information from the DSStudio Viewer Report Options Screen.

NC9 First select the Program/script: field an <Ctrl> v (paste) the EXE Info into the field.

Now go back to the DSStudio Viewer screen and click in the FileName Field and <Ctrl> a and <Ctrl> c.

Come back to the Task Scheduler and Select the Add arguments (optional) field and <Ctrl> v.  This will paste the report filename into the arguments field.

Windows Task Scheduler Page 6

That’s it click Finish to end and exit the Task Scheduler.  Now sit and wait for your reports to appear at the time you requested.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
How Can We Improve This Article?
Table of Contents

Sage 50 and Peachtree Accounting Data Services

Data Recovery

Sage 50 US and Peachtree Accounting Data File Repair Service.

 Fiscal Period Change

Change the fiscal period time for a Sage 50 or Peachtree Accounting Company.

Data Transition

Many data-related services, which include: Sage 50 Product Downgrade, Quote Removal Service, Failed Fiscal Year Close Fix, and bulk change inventory item costing.

Purge Service

Data Purging Service for Sage 50 and Peachtree Accounting.  Reducing file size and increasing program execution speed.

Sage 50 Shell Company

Rebuild your Sage 50 / Peachtree Company in half the time.

Sage 50 Quote Stripping

Unable to import transactions into a new company.  The quote " maybe getting in your way.

Get In Touch

In a world full of options, we wanted to take a moment and say thanks for choosing us.

Our Knowledgebase is available for your technical support questions. 

All Sage 50 and Peachtree Accounting support is provided for a fee.

Contact Us

Contact Form

Contact Info

Fort Lauderdale, Florida, USA
Minneapolis, Minnesota, USA

954 - 523 - 8570

s u p p o r t @ d s c o r p . c o m