ChristianSteven Business Intelligence Blog

The Top 4 Ways To Make Automating SQL 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

Automate, Schedule & Deploy SSRS Data Driven Subscriptions

Hundreds of companies of varying verticals and sizes rely on SQL Server’s reporting system. Known as SQL Server Reporting Services (SSRS), it is used to design and generate reports on a scheduled or adhoc basis. SSRS has a basic scheduler designed for simple automated report distribution, but what if your business requires complex event driven and data driven subscriptions? What if you not only needed to automate SQL reports, but you require tasks to be automated such as database updates or system alerts? In this blog, I will discuss how SSRS automated report generation, Data Driven Subscriptions, and business process automation using SQL-RD can solve this problem. 

Topics: business process automation business process management sql server reporting services ssrs sql-rd SQL server ssrs reports automate ssrs reports automated report generation SSRS automated report generation data driven subscription Microsoft Business Intelligence schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports

How To Trigger Threshold Alerts with SQL Server Reporting Services (SSRS)

Microsoft's SQL Server Reporting Services (SSRS) does a fine job of publishing reports and making them available on a timed schedule or on-demand. But, in recent years, are you finding that managers and customers are become more specific about when they want to receive their reports? Are they asking for reports to be triggered, not at a set time or day, but when a business event occurs?  If so, let us tell you more about threshold alerts.

Topics: sql server reporting services ssrs sql-rd ssrs reports data driven subscriptions business intelligence software business intelligence reporting data driven subscription 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

Are you 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