<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

Utilize SQL Server Reporting Services To Get The Most Of Technology!

Gone are the days, when technology used to be the differentiator in a business. In today's competitive era, what matters most is how you employ the technology at your disposal. Now you can make the most of the technology you have with the help of SQL-RD; which allows you to better utilize Microsoft Server Reporting Services in a better manner. It is a comprehensive tool which enables you to use the SQL suite in a truly professional manner.

Topics: sql server reporting services ssrs SQL Server Reporting Service Dynamic Schedule sql server reporting ssrs reports Package Report Schedule Single Report Schedule 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

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

Know How To Schedule SSRS Conditional Subscriptions

We have published a number of guides for scheduling SSRS reports to email, or data driving SSRS reports. Today let’s review how to schedule SSRS conditional subscriptions. Using  Event Based Schedules in SQL-RD, you can build complex workflows that can trigger RS reports based on events or conditions, for example database record has changed; email has been received; file has been updated, etc. You can monitor for these conditions at certain intervals, or in real-time. If these conditions are met, then it will run specified reports and even BPM tasks. Using SQL-RD to schedule SSRS conditional subscriptions is actually quite easy. The real challenge is working through exactly how to structure the schedule and the tasks.

Topics: ssrs sql-rd sql-rd guides for scheduling ssrs event-based schedule

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