Data Driven & Automated SSRS Reports with SQL-RD
SQL-RD is a dynamic, flexible, function-rich & intuitive automation tool for scheduling, exporting, distributing & delivering your Microsoft SQL Server Reporting Services (SSRS) Reports. Automate report delivery in SSRS & send the reports to printer, fax, folder, FTP, SMS, DropBox, Sharepoint & email in a number of formats including Excel, Word, PDF, Txt, CSV & more. SQL-RD contains powerful system, event triggered, data-driven & business process workflow functions which will make an instant impact on the efficiency of your business.
Automate SQL Reports
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, XML or CSV & who it should be sent to. SQL-RD will do the automated delivery for you, delivering reports to folder, email, printer, fax, DropBox, Sharepoint, FTP or SFTP! You can even select, manage & schedule reports hosted in different SSRS instances.
Date & Time Scheduling
Schedule SSRS Reports to run at a specific date & 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, & so on. And the same report can be scheduled to be run multiple times with different parameters, formats, frequencies, & destinations.
Respond to your business needs by setting schedules to run based on events & 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.
Dynamic & Data Driven
Use SQL-RD's unique Dynamic & Data Driven Schedule processes to trawl through your database to find the parameter values to use & then generate & deliver a unique report for each value.
- Ability to send Microsoft SSRS Reports to Google Sheets.
- Ability to use multiple SMTP servers to send emails.
- Password protecting Excel worksheets with 64-bit version of Excel.
- Additional performance improvements & minor bug fixes included in this release.
Ability to send emails with non-Latin language using UTF-8 encoding
A sample account has been added to the accounts library for use of basic testing
Errors caused by the email log within the system monitor have been resolved
Ability to create and re-use SSRS accounts
Ability to update your license details in the 'About SQL-RD' screen
Additional performance improvements
New group permission that allows SQL-RD administrators to force a SQL-RD users' Microsoft SSRS credentials to be entered when scheduling a report
Reports exported to Excel are now named as expected when merging reports in Data driven packages
New Dropbox custom task
Compatibility for TLS 1.2 for FTP/SFTP destination and custom task
.NET 4.6.1 only offered during installation if it is not already installed
Ability to use any SQL account used to connect to an existing SQL Server to host the SQL-RD database
More performance improvements
- Updated process watcher for manual executions
- Trial pop up during manual executions
- Email destination set to embed HTML now work as expected
- Additional performance improvements have been included in this release
Dropbox destination has been updated to work with Dropbox API version 2
SSIS variables now work as expected within an SSIS package task
Additional performance improvements have been included in this release.
Ability to schedule smart folders to run at a specified time
Data driven subscriptions set to update the database 'once for all records' now run as expected
All pages under the Resource tab now open directly in a web browser
Custom tasks set to run before report production and once for each generated report now execute as expected
Custom tasks set to run once for all records now execute as expected
Ability to use SSRS Linked reports
Ability to create a smart folder by RDL name
Snapshots can now be sorted by date
Editing a disabled schedule will no longer change the icon to appear enabled
Users can now see schedules created by other users in the same group
And more enhancements and fixes!
Data Driven Subscriptions With SQL Standard.