AllBusinessTools  

 

Product List

Home

 

Database Management

MSSQL to MYSQL

Access to MYSQL

Access to Oracle

Oracle to Access

MYSQL to Oracle

MYSQL to Access

DBF to MYSQL

Oracle to MYSQL

Access to MYSQL Pro

SQLRD

db Organizer Deluxe

Excel Everywhere

 

Special Promotions

Discounts / Coupons

 

Web Site     

About Us

Contact Us

Privacy Policy

 

 

 

 

 

 

 

  

 

 

 

  
  

SQL-RD

  

 

 

Automate single or batch SQL Reports daily, weekly, monthly etc.

 

More Information

  • Tired of spending the first week of every month manually running Microsoft® SQL Server Reporting Services reports?
  • Wish there was a way to schedule reports from multiple servers and manage the schedules in one place?
  • Wish you could schedule a batch of reports as a "Package" and have them all sent out in the same e-mail?
  • Want to output to a folder or fax or ftp or printer instead of just email?
  • Output into Word, Excel, PDF, HTM, TIF, RTF and more...?
  • Want to schedule reports which have parameters and re-use the reports over and over again?
  • Want a quick return on your investment?
  • Want to cut report writing, scheduling and administration costs?
  • Need a Microsoft® SQL Server Reporting Services reports scheduler which is reliable, stable, feature-rich and easy to use?

If you are a Microsoft® SQL Server Reporting Services reports user, and you have answered YES to any of the above, then SQL-RD is the program for you.

 

SQL-RD is an application for Windows that saves time and money by making it easy to define single or packages of Microsoft® SQL Server Reporting Services reports, schedule and run them automatically, and send the reports to print, fax, disk, ftp or email in a number of standard formats.

Simply set up a schedule stating how often you would like each report to run, whether you'd like the output in Word, Excel, HTML, RTF, Acrobat, text format, and more and who it should be sent to.

Use standard frequencies like Daily, weekly, monthly or set up your own custom frequencies e.g. 4-4-3, every other day, third Monday of the month.

It's easy to schedule reports to run at a specific date and time, or to run them hourly, daily, weekly, or monthly.

The same report can be scheduled to be run multiple times with different parameters, formats, frequencies, and destinations.

Features

  • Schedule reports to run at a specific date and time or Hourly, Daily, Week Days, Weekly or Monthly.  Or set up your own custom frequency calendars.
  • Export reports to many file formats including Microsoft® Word, Rich Text (RTF), Excel® (XLS), HTML, PDF, CSV, DOC and lots more
  • Email your report (CC and BCC too!) using SMTP, Outlook®, Exchange®, MAPI or SQL-RDMail.
  • Print your report.
  • Schedule your report to print to multiple printers (Bulk Printing)
  • Send your report to a local or  network folder or directory.
  • Transfer your report to an FTP folder or destination.
  • Fax your report.
  • Run custom actions before your report is exported.
  • Run custom actions after the report export has completed.
  • The same report can be scheduled to be run multiple times with different parameters, formats, frequency and destinations.
    "Dynamic" schedules will reel through a database, automatically populate parameter values, and send reports to the corresponding email address from a database. Use our easy interface, or paste in your own fancy SQL script.  With some manipulation, add conditions and criteria, and lots more...

 

More Information

 

 

 

SQL-RD

More Information

Trial Download

 

Below is a functionality grid which should tell you which Editions have which functionality.  If the functionality you are looking for is not listed here, but is in your evaluation edition, then assume that it will be in every Edition.

At the bottom of the grid is a description of  your FREE 12 month maintenance entitlement, what it will cost for subsequent years, and Edition price list.  This list is correct at the time of publication.  We reserve the right to change the prices without prior notice. 

    Bronze Silver Gold Platinum Enterprise Enterprise Pro Ent Pro Plus Corporate
                   
General                
  Max Number of Schedules 15  30 50 Unlimited Unlimited Unlimited Unlimited Unlimited
  Number of Seats (Installations) permitted 1 1 1 1 Up to 10 Up to 15 Up to 20 1 Mstr + 10 Slaves
Schedules                
  Schedule Single Reports ü ü ü ü ü ü ü ü
  Schedule Packages of reports ü ü ü ü ü ü ü ü
  Automation Schedules      ü ü  ü ü ü ü
  Dynamic Schedules           ü ü ü
  Event Based Schedules             ü ü
Parameters                
  Single value parameter selection ü ü ü ü ü ü ü ü
  Range of values     ü ü ü ü ü ü
  Read parameter from database         ü ü ü ü
Parameter Functions              
  SQL-RD Functions         ü ü ü ü
  Write your own functions         ü ü ü ü
Dynamic Scheduling                
  Auto populate dynamic parameter from database           ü ü ü
  Pick email from same table as parameter           ü ü ü
  Pick email from different table to parameter           ü ü ü
  Limit schedule based on email field selection criteria           ü ü ü
  Dynamic email content           ü ü ü
  Auto password protect PDF output             ü ü
  Dynamic folder hierarchy             ü ü
  Dynamic output file naming             ü ü
Event Based Scheduling (Triggers)              
  Database Record Exists             ü ü
  Database record does not exist             ü ü
  Database record has changed             ü ü
  File Exists             ü ü
  File does not exist             ü ü
  File has been modified             ü ü
  File has not been modified             ü ü
  Window is present             ü ü
Static Scheduling (Single reports and packages)            
  Auto Populate static parameter from database         ü ü ü ü
  Pick email from different table to parameter           ü ü ü
  Limit schedule based on email filed selection criteria           ü ü ü
  Dynamic email content           ü ü ü
  Convert single schedule to package           ü ü ü
  Split package into single schedules           ü ü ü
Email Delivery                
  Output to email ü ü ü ü ü ü ü ü
  Max number of recipients per schedule 50  50  50 50 50 Unlimited Unlimited Unlimited
  Silent integration with MS Outlook/Exchange ü ü ü ü ü ü ü ü
  Use Outlook/Exchange Address Book ü ü ü ü ü ü ü ü
  Use SQL-RD's Mail Server ü ü ü ü ü ü ü ü
  Use Single SMTP account ü ü ü ü ü ü ü ü
  Use Multiple SMTP accounts           ü ü ü
  Use SQL-RD's own address book         ü ü ü ü
  Read email address from a database         ü ü ü ü
  Read email addresses from a mailing list (text file)             ü ü
  Add another file as attachment to email   ü ü ü ü ü ü ü
  cc and bcc fields         ü ü ü ü
Print Delivery                
  Output to single printer ü ü ü ü ü ü ü ü
  Multiple copies to a single printer ü ü ü ü ü ü ü ü
  Output to multiple printers (Bulk Printing)         ü ü ü ü
  Multiple copies to multiple printers         ü ü ü ü
File Delivery                
  Output to folder ü ü ü ü ü ü ü ü
  Output to FTP folder       ü ü ü ü ü
FAX Delivery                
  Manual output to fax driver ü ü ü ü ü ü ü ü
  Automated Faxing         ü ü ü ü
  One recipient per schedule/package         ü ü ü ü
  Multiple recipients per schedule/package             ü ü
Other Delivery                
  SMS (Cell Phone Text)             ü ü
  File Transfer via RAS to a remote PC             ü ü
Output Formats                
  MS Excel (XLS) ü ü ü ü ü ü ü ü
  MS Word (DOC)     ü ü ü ü ü ü
  Rich Text (Exact Format) (RTF)     ü ü ü ü ü ü
  Lotus (WK1, WK3, WK4, WKS)     ü ü ü ü ü ü
  Web Archive  (MHTML) ü ü ü ü ü ü ü ü
  HTML (HTM) ü ü ü ü ü ü ü ü
  Acrobat (PDF) ü ü ü ü ü ü ü ü
  Data Interchange Format (DIF)     ü ü ü ü ü ü
  dBase II, III, IV (DBF)     ü ü ü ü ü ü
  Character Separated (CSV) ü ü ü ü ü ü ü ü
  XML ü ü ü ü ü ü ü ü
  Tiff (TIF) ü ü ü ü ü ü ü ü
Frequencies                
  Every day ü ü ü ü ü ü ü ü
  Every week day ü ü ü ü ü ü ü ü
  Every Month ü ü ü ü ü ü ü ü
  Every Year ü ü ü ü ü ü ü ü
  Repeat every x hours until… ü ü ü ü ü ü ü ü
  Custom Frequency Calendar e.g 4-4-3     ü ü ü ü ü ü
  Custom Recurring Options           ü ü ü
  Event Based              ü ü
DB Logon                
  db logon for main report ü ü ü ü ü ü ü ü
  Logon credentials include server name ü ü ü ü ü ü ü ü
Exception Handling                
  On failure retry scheduling ü ü ü ü ü ü ü ü
  If report is blank do some action ü ü ü ü ü ü ü ü
  If report is blank, send alternative email ü ü ü ü ü ü ü ü
Output Options                
  Custom naming of output file ü ü ü ü ü ü ü ü
  Selection of date/time stamp format ü ü ü ü ü ü ü ü
  Custom date/time stamp for single reports ü ü ü ü ü ü ü ü
  Global custom date/time stamp for package ü ü ü ü ü ü ü ü
  Specify output extension (.xyz) ü ü ü ü ü ü ü ü
  Output Compression         ü ü ü ü
  Embed output into email body ü ü ü ü ü ü ü ü
  Custom date/time stamp for reports in packages ü ü ü ü ü ü ü ü
Special Excel Output Options                
  Export a package into individual worksheets in one workbook             ü ü
Special PDF Output Options                
  Merge a package into a single PDF             ü ü
  PDF export with navigation tree             ü ü
  Password protect PDF output             ü ü
  Watermarks in PDF output             ü ü
Custom Actions             
  Run action after the schedule is executed         ü ü ü ü
  Run action before the schedule is executed           ü ü ü
  Run action before and after the schedule is executed           ü ü ü
  Run action on successful execution of schedule         ü ü ü ü
  Run action on successful delivey of report