Recently it has been necessary to send out regular batches of information to clients in order for them to be prompt with reporting and feedback to underwriters. Luckily using SQL and SSRS this was easily achieved as they work hand in hand with the Aladdin System. Instead of looking at creating new code in the system to generate and save and send reports out I have implemented the SSRS subscriptions to automate the process.
SSRS allows us to generate reports that access data directly from the SQL database, this means that no additional applications are required. Logging on to the SSRS reports server one can go to the desired report and create what is called a subscription. The subscription can contain information about where you want to draw the report from which database to access and when you want it to trigger. This generates the report for us SSRS can then save the report to disk if desired and also has the ability to link into a mailbox and automatically send out these reports. Using this we could conveniently send out month end reports such as data on the accounting.
SSRS allows us to both schedule reports and draw them on demand, also the versatility of creating reports means that customised reports can be built in short periods of time. These factors make the marriage of SQL Server and SSRS reporting an invaluable setup to keep information at the ready and allow for easy analysis of a product or businesses statistics.