<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=574116576097555&amp;ev=PageView&amp;noscript=1">

ChristianSteven Software Business Intelligence Blog

SQL Server Reporting Services: Benefits of a 3rd Party Scheduler

SQL Server has an internal SSRS Reports scheduling system that can manage and distribute your report subscriptions. Does it do the job? Do SSRS’ internal features satisfy all of the business’ needs? In some cases, firms look to 3rd party solutions to complete their projects. Some solutions enable a greater flexibility in subscription publication, or offer a wider array of scheduling options, while others help manage SSRS Reports. Most importantly, using a 3rd party solution such as SQL-RD can provide a much higher ROI for initial, ongoing and future costs.

Topics: sql-rd SQL Server Reporting Service SQL server sql server reporting data driven subscriptions business intelligence reporting Microsoft Business Intelligence schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports

How To Get Extra Umph Out Of Your SSRS Reports

Using SQL-RD to schedule SQL reports? If so you are already pretty familiar with SQL-RD’s powerful schedule functions such as the Event Driven scheduler or the Data Driven Subscription scheduler. These functions are powerful tools that enable you to dynamically send a report to various users, perform various business process management tasks, and much more. However, there are a number of tools in the SQL-RD toolbox that can make the scheduling experience even better. 

Topics: sql server reporting services ssrs SQL server ssrs reports data driven subscriptions data driven subscription sql reports data-driven schedule Microsoft Business Intelligence schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports

How to Publish SQL Server Reports Outside of SSRS

Continuing our series on SQL-RD and ways “out of system workflows” maximize SSRS’ capabilities, let’s explore exactly how SQL-RD can publish SQL Server reports. In the past, we have looked at why an administrator would want to schedule SSRS reports outside of SQL Server. Reasons ranged from increased flexibility, more export options, and report output security. In this article, we will run through setting up two of SQL-RD’s most basic scheduling functions: the Single Report Schedule and the Packaged Report Schedule. Though this article isn’t meant to be a fully fledged tutorial, it will give administrators feel for how SQL-RD can be used to publish SQL Server reports.

Topics: sql-rd SQL Server Reporting Service SQL server ssrs reports data driven subscriptions sql server reports data driven subscription Microsoft Business Intelligence schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports

5 Ways To Use Event Driven Subscriptions With SSRS

In the past we have discussed how Data Driven subscriptions can be created in SQL-RD to deliver reports to various users and destinations. In SQL-RD, SSRS reports scheduling can also be accomplished based on certain conditions. Once these conditions are met, then the associated SQL report will be triggered based on given parameters, and then delivered to a specified location. One could build an Event Driven system inside of SQL Server, however, SQL-RD provides the advantage of require little to no coding and shortened setup time. In other words, there is no need for you to provide the logic necessary to drive the report. Moreover, managing the logic and the subscriptions within SQL-RD is both easier and more efficient. There are a number of conditions that could be created with Event Driven Subscriptions. Let’s look a few that are built into SQL-RD.

 

Topics: sql server reporting services ssrs Event Based Schedules SQL server ssrs reports scheduling event driven subscriptions schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports

5 New SQL Server Features That Increase Operational Efficiency

If you keep up with the latest in technological advances, you have probably already heard about Microsoft's announcement to create SQL Server for Linux. Sure, this is a huge announcement, but now what? We're going to go through some of the top features of SQL Server and see how you can use them to increase operational efficiency.

Topics: big data Business Intelligence Solutions SQL server business intelligence systems data driven subscriptions business intelligence software SQL Server 2016 business intelligence reporting data driven subscription Microsoft Business Intelligence business intelligence online