<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

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 sql server reports 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 business intelligence software SQL Server 2016 business intelligence reporting Microsoft Business Intelligence business intelligence online

How To Generate An SSRS Report As A Password Protected PDF

Though SSRS already has built-in functions that allow you to schedule and run a SSRS report to PDF, there are plenty of reasons why you would rather rely on a dedicated scheduler to process reports into PDF files. Advanced report encryption including password protected PDF, PGP, and Zip encryption methods can ensure that reports containing vital data are secure. Adding an expiration date to an SSRS reports limits the reports availability to users even after it has been delivered. PDF permissions ensure the users cannot tamper with the PDF file as well. Let’s dive a bit deeper and find out how to use these features to not only format your report into PDF but keep them secure!

Topics: sql server reporting services ssrs sql-rd pdf SQL server ssrs reports data driven data driven subscriptions ssrs reports automation data driven subscription password protected Microsoft Business Intelligence schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports