ChristianSteven Software Business Intelligence Blog

7 reasons to use SQL Reporting Services (SSRS) to Design, Generate, and Deploy Business Reports

SQL reporting services is a server based report designer, builder, and deployment engine made by Microsoft. This can be used to prepare and deliver various interactive and printed reports. With SQL reporting services combined with SQL Server, firms have a unified solution for both report design and data warehousing. SSRS can help you to create tabular, graphical and free-form reports from relational, multidimensional and XML based data sources. The reports can also be published and accessed on demand. SSRS also has a built in scheduling tool to perform basic report deployments via email, file share, or SharePoint.

Topics: business intelligence sql server reporting services ssrs sql-rd SQL reporting services Business Intelligence Solutions business intelligence systems 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

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