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

How to Enhance SSRS Scheduling with SQL-RD

In our ever-changing technological world, the foundation of a business's success is highly reliant upon the business technology that is available in today's market. In this competitive era, what matters most is how you utilize and apply that technology. Using software tools, such as SQL-RD, I will illustrate how to enhance SSRS scheduling. You can employ a more advanced technique that can set your business apart from your competitors. SQL-RD is a comprehensive software that allows you to use Microsoft SQL-Server Reporting Services (or SSRS) in a more proficient manner.

Topics: Single Report Schedule Microsoft Business Intelligence schedule ssrs report ssrs subscription ssrs subscriptions schedule sql report schedule ssrs reports schedule sql reports package report schedules how to enhance ssrs scheduling enhance ssrs scheduling dynamic package schedules

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