ChristianSteven Software 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