ChristianSteven Business Intelligence Blog

Merge SSRS Report Output With SQL-RD's Package Schedule

Imagine that the management team needs to receive 10 weekly status reports that include finances, inventory, sales etc. As usual, you have 10 subscriptions setup that deliver these reports. Everything is working just fine, then suddenly management decides that they no longer want to fuss with 10 different reports and 10 different emails. Instead, they want one document that encompasses all the weekly information they need. Great, now you have to write a whole new report, deploy it, and then set up the subscriptions all over again. Or do you? Using SQL-RD's Package Schedule, you can merge SSRS report output into a single PDF, text, or Excel file without the need to change the reports.

Topics: business intelligence sql-rd ssrs reports automate ssrs reports deliver SSRS reports package schedule ssrs outputs

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

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

Gone are the days, when technology was 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 data driven subscriptions data driven subscription 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

The Top 4 Ways To Make Automating SSRS Reports Easy

Report publishing can often be a chore for SQL server administrators. Users constantly requesting reports or the unending duty of managing report subscriptions. There is a way to end this suffering. No, we are not talking about a career change. The only way to release this burden is automating SQL reports! When using a third party program, it can actually be easy, and if you are nerdy enough, fun! Using an external tool such as SQL There are a few ways to automate your SSRS reports. 

Topics: sql-rd Dynamic Schedule ssrs reports data driven subscriptions event driven subscriptions data driven subscription sql server reproting services schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports automating sql reports