ChristianSteven Business Intelligence Blog

Automated Reporting For SQL Server - What's the Point?

Why should you bother employing automated reporting for SQL Server? Today’s world is dominated by the notion of “self-serve business intelligence.” Users want their data immediately and have the desire to run the reports the way they want, manipulate the data as they choose, and present the information in the way they think is best. Waiting on an administrator to send a report, or an automated system to place the report in their SharePoint directory is just too time consuming and can present some possible security risks.

Topics: report automation SQL server Articles schedule sql reports automate ssrs report delivery ssrs is a valuable business intelligence tool enhance ssrs scheduling self-service ssrs software automated reporting for SQL Server Self-serve business intelligence

What To Look For In An SSRS Replacement

Are you ready for an SSRS replacement? You have plenty of options, but keep in mind that not all products provide the same benefits or results. Since any business intelligence solution is ultimately about results, it’s essential to review a potential replacement for your SSRS with the same scrutiny you used to choose your primary BI software. The two most critical elements you should look for are automation and access.

Topics: ssrs data driven subscription ssrs reports scheduler ssrs is a valuable business intelligence tool self-service ssrs software SSRS replacement automated functions to improve efficiency scheduling options in your SSRS replacement

The Best Self-service Reporting SSRS Software For Time Management

Time management is a never-ending fight for decision makers in any industry. Programs like self-service reporting SSRS software can change that. This software makes BI tasks much easier and restores a more natural form of labor distribution. All of this adds up to saved labor hours.

Topics: self-service business intelligence self-service reporting tools self-service reporting ssrs self-service reporting software self-service reporting ssrs software tools self-service ssrs software self-service reporting in business intelligence

Do You Know How To Schedule SSRS Conditional Subscriptions?

We have published a number of guides for scheduling SSRS reports to email, or data driving SSRS reports. Today let’s review how to schedule SSRS conditional subscriptions. Using  Event Based Schedules in SQL-RD, you can build complex workflows that can trigger RS reports based on events or conditions, for example database record has changed; email has been received; file has been updated, etc. You can monitor for these conditions at certain intervals, or in real-time. If these conditions are met, then it will run specified reports and even BPM tasks. Using SQL-RD to schedule SSRS conditional subscriptions is actually quite easy. The real challenge is working through exactly how to structure the schedule and the tasks.

Topics: ssrs sql-rd sql-rd guides for scheduling ssrs event-based schedule enhance ssrs scheduling self-service reporting ssrs self-service reporting ssrs software tools self-service ssrs software