ChristianSteven BI Blog

Sarah Turnwald

Sarah Turnwald

Customer Experience Manager at ChristianSteven Software.

Recent Posts by Sarah Turnwald:

Deploy SSRS Data Driven Subscriptions On A Shoestring

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. Additionally, I will give a little insight into Zintel, a leading provider of communications technology solutions to businesses across New Zealand and Australia, and how SQL-RD solved this problem for them.

Topics: SQL-RD SSRS data driven subscriptions SSRS Reports

How to Email Crystal Reports From Multiple Email Accounts

Imagine the following scenario: Your Logistics Department needs all inventory and fulfillment reports sent from their email address. Your Sales Group wants daily sales reports to come from a separate email address. Meanwhile, invoices need to be sent from the Customer Service Teams' own email address. The problem? Your current Crystal Reports distributor only allows for one email account.

Here at ChristianSteven Software, we have your solution. Our Crystal Reports Distributor (or CRD) software allows multiple SMTP accounts to be created and used. This gives the reporting admin the capability to automatically email Crystal Reports from any account at any time.

Topics: Crystal Reports CRD Crystal Reports Scheduler

How To Generate An SSRS Report As A Password Protected PDF

Though SSRS already has built-in functions that allow you to schedule and run a SSRS report to PDF, there are plenty of reasons why you would rather rely on a dedicated scheduler to process reports into PDF files. Advanced report encryption including password protected PDF, PGP, and Zip encryption methods can ensure that reports containing vital data are secure. Adding an expiration date to an SSRS reports limits the reports availability to users even after it has been delivered. PDF permissions ensure the users cannot tamper with the PDF file as well. Let’s dive a bit deeper and find out how to use these features to not only format your report into PDF but keep them secure!

Topics: SSRS SSRS Reports SQL-RD password protected

5 Ways To Use Event Driven Subscriptions With SSRS

I have previously discussed how Data Driven subscriptions in SSRS can be created using SQL-RD to deliver reports to various users and destinations, even when using SQL Standard Edition. In SQL-RD, SSRS reports scheduling can also be accomplished based on certain conditions. Once these conditions are met, then the associated SQL report will be triggered based on given parameters, and then delivered to a specified location. One could build an Event Driven system inside of SQL Server, however, SQL-RD provides the advantage of require little to no coding and shortened setup time. In other words, there is no need for you to provide the logic necessary to drive the report. Moreover, managing the logic and the subscriptions within SQL-RD is both easier and more efficient. There are a number of conditions that could be created with Event Driven Subscriptions. Let’s look a few that are built into SQL-RD.

Topics: ssrs reports scheduling event driven subscriptions SSRS SQL-RD

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: SQL-RD business intelligence Business Intelligence Solutions Microsoft Business Intelligence business intelligence reporting business intelligence software business intelligence systems SSRS schedule ssrs report schedule ssrs reports schedule sql report schedule sql reports data driven subscription data driven subscriptions