ChristianSteven BI Blog

Merge SSRS Report Output With PBRS 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 PBRS'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 SSRS SSRS Reports SSRS Reports Automation PBRS

Business Schedulers for SQL Reporting Services: SSRS Report Format, Delivery, and Options

The SSRS report has been written, parameters have been set, and now it’s time to go live with the report. There are still a few lingering questions before users can start happily reading the report. How will they subscribe to the report? What format will the report be? What kind of security needs to exist around the report? These questions can determine what kind of tool to use to schedule your SSRS report.

Topics: SSRS SSRS Reports SSRS Reports Automation SSRS Reports Scheduler PBRS

What Do You Do When An Automated Email Report Refuses To Email Itself?

There’s nothing more frustrating than an automated email report that refuses to email itself. On a bad day, it may feel like your business intelligence solution is working against you, and nothing drives that feeling home like an SSRS data driven subscription email hiccup. We’ve examined some of the common problems and came up with a few simple solutions.

Topics: SSRS Data Driven Schedules SSRS Reports SSRS Reports Automation SSRS Reports Scheduler PBRS

We Make SSRS Easy! Automate Your Reports Using PBRS

Would you like to manage your SSRS Reports distribution needs with greater effectiveness, speed, and efficiency? If so, PBRS is the automation tool for you. PBRS is a dynamic, flexible, function-rich and intuitive automation tool for scheduling, exporting, distributing and delivering your Microsoft® SQL Server Reporting Services (SSRS) Reports. This scheduler will help you make quick, insightful business decisions at a lower cost of ownership.

Topics: Business Intelligence SSRS ChristianSteven SSRS Reports Automation SSRS Reports Scheduler PBRS

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: SSRS SSRS Reports SSRS Reports Automation SSRS Reports Scheduler PBRS