SSRS Scheduled Report Setup
by Christian Ofori-Boateng on Sep 9, 2018 11:56:00 AM
Depending on your SQL Server edition, SSRS has some built-in scheduling functions that allow administrators to schedule SSRS reports to email. Many situations require reporting administrators to turn to PBRS, an “out of system” workflow tool for scheduled SSRS reports. In the past, I …
Merge SSRS Report Output With PBRS Package Schedule
by Christian Ofori-Boateng on Sep 2, 2018 11:43:00 AM
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 f …
Business Schedulers for SQL Reporting Services: SSRS Report Format, Delivery, and Options
by Christian Ofori-Boateng on Aug 5, 2018 7:47:00 AM
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 se …
What Do You Do When An Automated Email Report Refuses To Email Itself?
by Christian Ofori-Boateng on Jul 31, 2018 8:10:00 AM
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 exami …
How To Generate An SSRS Report As A Password Protected PDF
by Christian Ofori-Boateng on Jul 18, 2018 6:30:00 AM
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 Z …