• Home
  • Products
    • CRD
    • MARS
    • SQL-RD
  • Member Area
    • CRD
    • MARS
    • SQL-RD
    • Forgotten Password
  • Contacts
  • Support 
    • CRD
    • MARS
    • SQL-RD

.

  • Back to SQL-RD
  • Bookmark this page

 

 





1.
Single Report Schedule
Schedule a simple Access Report to export to HTML every weekday at specified times of the day.
2.
Packaged Schedule
Schedule a number of reports as a "package" to export to HTML every Monday and Friday at specified times of the day.
3.
Automation Schedule
Schedule to create a specified folder on the first Monday of every month.
4.
Event-Based Schedule
Fire off and deliver reports automatically when an event occurs.  Here are some examples.
    
  • If a file exists
  • If a file has been modified
  • If a database record exists
  • If a database record changes
  • If an unread email is present

 

  • Advanced: If a new database record exists, use  the data in the record to send an email to a recipient
  • Advanced: If an unread email is present use data in the email to create a new database record.

 

5.
Event-Based Package
Group a number of event-based activities and determine timing, order of execution and more
6.
Dynamic Schedule
SQL-RD will reel through a list of parameter values, generate a unique report for each value, and deliver each report to a unique destination (e.g. email address, folder, etc). Saves you from having to write and maintain multiple schedules.
 
  • Simple Dynamic Schedule
  • Advanced Dynamic Schedule
7.
Dynamic Package
Same as Dynamic Schedules, but multiple reports to specified destinations.
   
  • Simple
  • Advanced
 
8.
Calendar
Create your own scheduling frequencies using Custom Calendars (e.g. 4-4-3).  Or use Exception Calendars to skip special days (e.g. public holidays)
  
  • Custom Calendar
  • Exception Calendar
9.
Report Options
Set up logon credentials for the reports.  Keep copies of exported reports for x days.
10.
Report Parameters
How to tell SQL-RD what report parameter values to use.
11.
Exception Handling
Retry x times on failure. What to do if the report "hangs". Take some action if the report returns no data.
12.
Destinations
SQL-RD will send your reports to a number of destinations.
    
  • Printer
  • Fax
  • Email
  • FTP
  • Disk
  • SMS (Cell phone text)
13.
Default Destinations
Set up a number of destinations (email, printer, fax, SMS, folder and FTP) and use them over and over again.
14.
Output Formats
Learn how to quickly set up schedules to export to pdf, tiff, xls, and many more formats.  Also shown are output features e.g. custom report naming, zipping the export, zip encryption, deferred delivery, and lots more.
   
  • Acrobat (PDF)
  • HTML (HTML)
  • Lotus 1-2-3 (WK1)
  • Lotus 1-2-3 (WK3)
  • Lotus 1-2-3 (WK4)
  • Lotus 1-2-3 (WKS)
  • Microsoft Excel (XLS)
  • Microsoft Word (DOC)
  • Rich Text (RTF)
  • Data Interchange Format (DIF)
  • Web Archive (MHTML)
  • XML (XML)
  • Character Separated (CSV)
  • Text (TXT)
  • TIFF (TIF)
  • dBase II (DBF)
  • dBase III (DBF)
  • dBase IV (DBF)
15.
Custom Tasks
When the report has been delivered, run a batch file, update a database, send an email and more.
16.
SQL-RD Constants
Insert Constants (e.g. Yesterday's Date, CurrentScheduleName, ExportedFileName) to automate otherwise repetitive and mundane processes.
17.
User Management
 
  • Set up and manage and assign schedule to users
  • Set up and assign users to a security group
18.
Using Outlook (MAPI)
Set up SQL-RD to use MAPI to send emails.
19.
Integrating the NT service Exchange Server
Set up SQL-RD to use Exchange Server to send emails.
20.
Using SQL-RDMail
Set up SQL-RD to use SQL-RDMail to send emails.
21.
Using SMS (Cell phone) text
Set up SQL-RD to send SMS text alerts.
22.
Using SMTP
Set up SQL-RD to use SMTP to send emails.
23.
Using GroupWise
Set up SQL-RD to use GroupWise to send emails.
24.
Auto System Backup
Automatically backup the SQL-RD system and files.
25.
Application Scheduler
Set up SQL-RD to use the Application Scheduler.
26.
NT Service Scheduler
Set up SQL-RD to use the Windows (NT) Service.
27.
Address Book
   
  • Setting up Contacts
  • Setting up groups
  • Exporting & Importing
  • Editing Contacts & Groups
  • Deleting Contacts & Groups

 

28.
Smart Folders
Use smart folders to group schedules and to report on schedule activity
29.
User Defaults
Don't type the same password, email body, signature etc over and over again.  With User Defaults you can enter than once, and reuse them each time your write a schedule.
30.
Audit Trail
Set up an audit trail showing activities that have happened in SQL-RD.
31.
Remote Administration
Connect to and administer remote installations of SQL-RD from your PC.
32.
Housekeeping
Set up folder housekeeping and other automated processes to help keep your system and pc robust and stable.
33.
Clustering
Use multiple PCs to schedule hundreds of reports.  The "Master" controls a bank or "cluster" of PCs ("slaves") and instructs them what to run and when.  See how easy it is to set this up.
34.
Migrating the SQL-RD database from file system to an ODBC compliant database
The SQL-RD data (schedule info etc) is stored in a Access database locally.  Migrating to a SQL, Oracle or other ODBC compliant database gives you enterprise scalability and reliability - and gives you the ability to write triggers, stored procedures and add custom functionality.

Important:  Click here and read this document before you begin the process.

35.
Migrating from an ODBC compliant database back to the local file system
Migrate back to the local file system.  Useful if you know your server is going to be down for maintenance.

 

© Copyright 2002-2008 ChristianSteven | All Rights Reserved | Website Design by Inverse-Logic