ChristianSteven BI Blog

Benefits of Automated Report Delivery in SQL Reporting Services

When it comes to gathering data, the process of building the report and sending it out is possibly the most intense. Microsoft created SQL reporting services as a server based report designer, builder, and deployment engine. The service prepares and delivers a variety of both interactive and printed reports. With SQL reporting, accessing and delivering reports is made simple. By automating the service, you only improve its usefulness. 

Topics: SSRS SSRS Reports SSRS Reports Scheduler PBRS

SSRS Enterprise Scheduling Functionality Comes to SQL Server Standard

Using SQL Server Standard? Tired of seeing everyone else using SQL Server Enterprise scheduling while you languish in a lower edition? Indeed SQL Server Enterprise scheduling brings handy features such as data-driven SSRS report scheduling and business process management that aren’t available in SQL Server Standard. However, there is a way to keep up with these features without upgrading your SQL Server edition. With PBRS, you can schedule SSRS reports, SSIS packages, and tackle other business processes such as updating database records.

Topics: SSRS SSRS Reports Scheduler PBRS

3 Ways PBRS Can Serve As An Advanced SSRS Report Manager

Not only is PBRS a handy tool for scheduling SQL Server Reports, it can be a great way to manage SSRS report subscriptions. Many PBRS users have enjoyed the ability to schedule SSRS reports with expanded options such as report encryption, additional formats, and more destinations such as SharePoint & Dropbox. In addition to the advanced subscription distribution features PBRS has to offer, it can also act as an SSRS report manager. Let’s look at three ways PBRS can help SQL Server admins manage their SSRS subscriptions.

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

SSRS Scheduled Report Setup

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 have discussed in great detail the reasons why administrators use PBRS to schedule reports, but now I will cover how administrators schedule SSRS reports to email.

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