MARS Features

Event Triggers
Event Triggers
Date & Time Scheduling
Date & Time Scheduling
Dynamic and Data Driven
Dynamic and Data Driven
Pre & Post Delivery Automation
Pre & Post Delivery Automation
Customize Report Outputs
Customize Report Outputs
Package Schedules
Package Schedules
Event Triggers

Event Triggers

Distribute MS Access Reports and respond to your business needs by setting schedules to run based on events and triggers rather than date. Add real-time monitoring to your MS Access Report distribution process with MARS's Event Based Schedules, reports are fired off when events occur e.g. database value is present, file is modified, window is open, an email is received, etc. MARS makes sure the reports are created and distributed on time and error-free.

Date & Time Scheduling

Date & Time Scheduling

It's easy to schedule Access Reports to run at a specific date and time, or to run them hourly, daily, weekly, or monthly or set up your own custom frequencies e.g. 4-4-3, every other day, third Monday of the month, and so on. And the same report can be scheduled to be run multiple times with different parameters, formats, frequencies, and destinations. It makes Access Reports scheduling simple, hassle-free and convenient for you.

Dynamic and Data Driven

Dynamic and Data Driven

Use MARS's Dynamic and Data-Driven Schedule processes to trawl through your database to find the parameter values to use and then generate and deliver a unique report for each value. Bring advanced Data-Driven functionality to your Access Reports distribution infrastructure.

Pre & Post Delivery Automation

Pre & Post Delivery Automation

Once your schedule has been executed, why stop there? Use MARS's Custom Actions to run another program, enter values in a database, modify a file and lots more. Or use Automation Schedules for general business process automation without scheduling any reports at all.

Customize Report Outputs

Customize Report Outputs

  • Acrobat (PDF): Include watermarks & stamp, add bookmarks based on group header, set document properties, add password protection, merge a package of multiple reports into a single PDF file & merge any existing PDF files into a single file.
  • Character Separated (CSV): Use any character separator, or use "tab", choose comma, or any delimiter.
  • MS Excel (XLS), Data Only, Excel 7, 8, & 97-2000: Customize the worksheet (tab) name, burst report groups into separate worksheets in the same workbook, merge a package of multiple reports as individual worksheets (tabs) in a single workbook, set password protection, set document properties.
  • MS Word (DOC): Set document properties, raster Image (TIF), choose from Uncompressed, LZW, RLE and fax formats; Select 24-bit color, 256 color or Black & White.

Exception Handling

Use Exception handing to determine what should happen if a reports fails to run or if the report executes but contains no data. For example: If a report takes longer than the specified amount of time to run, treat the schedule as an error and follow the appropriate action. The “Auto-calculate” option instructs MARS to automatically determine how long a schedule should take to run the report. If it takes longer than the calculated amount of time, then it is an error. Should an error occur with a schedule, specify the retry interval and number of times the schedule should attempt a retry. Check for blank reports and determine what actions should be taken if a blank report is detected.

Package Schedules

Package Schedules

Set up a package of reports to be generated at defined intervals and delivered to one or more defined destinations - together. For example, a monthly report pack (consisting of a number of reports) can be sent to a client with all reports attached to the single email or compressed into a single zip file, or merged into a single Excel workbook, or PDF file before delivery.