SQL-RD 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
Exception Handling
Exception Handling
Event Triggers

Event Triggers

Distribute SSRS 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 SSRS Reports distribution process with SQL-RD'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. SQL-RD makes sure the reports are created and distributed on time and error-free. Just what you want from a SSRS Data Driven Automation.

Date & Time Scheduling

Date & Time Scheduling

It's easy to schedule SSRS 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 SSRS Reports scheduling simple, hassle-free and convenient for you.

Dynamic and Data Driven

Dynamic and Data Driven

Use Dynamic Schedules to export multiple instances of the same report. For each instance, SQL-RD will automatically enter the required parameter values, export the report and deliver the results to the corresponding email, folder, FTP, printer or fax. The parameters and destination are read from your own database. For example, run the same report for dozens of clients without writing a schedule for each client. Use Data Driven Schedules to bring Reporting Services functionality to SSRS Reports. Drive all variables of your reporting requirements (parameters, destinations, output format, etc) from database tables and queries.

Pre & Post Delivery Automation

Pre & Post Delivery Automation

Once your schedule has been executed, why stop there? Use SQL-RD's unique 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

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 SQL-RD 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.