Advanced 365

Share This Page



Case Study

"We chose Advanced 365 as they demonstrated the breadth of capability and flexibility required to deliver such a key business application"
Morgan Sindall

Morgan Sindall

Download Case Study

Reporting Services Consolidator

Microsoft PartnerReporting Services Consolidator

Consolidate Your Existing Reports and Documents

The Advanced 365 Reporting Services Consolidator provides a BI and Reporting solution that has been specifically created to enable organisations to make best use of the data they already have, converting existing data into business information thus offering better decision making capabilities. This delivers a risk free approach to addressing an organisations BI and Reporting issues by leveraging their existing investment and removing the time and cost burdens of implementing a new system.

The Advanced 365 Reporting Services Consolidator helps businesses grow with the economic recovery through increased transparency of vital business information:

The Solution

Proof of Concept

The first stage of any BI engagement with Advanced 365 is a 5 day proof-of-concept which sets out to deliver a working report that the customer can use going forwards as a useable business tool. This approach has been adopted because it offers a risk free solution that for minimal cost demonstrates how the Advanced 365's Reporting Services Consolidator solution will be of benefit to your business.

At the end of the proof of concept stage the customer is under no commitment to continue working with Advanced 365 should the solution not prove to be effective. This is in stark contrast to many of the other solutions available today where a significant upfront investment is often required before any return on investment can be proved.

Technology Overview

The Reporting Services Consolidator leverages the power of Microsoft SQL Reporting Services (SSRS) and the Microsoft SharePoint platform to automate the report consolidation process. The Reporting Services Consolidator uses SharePoint Document Libraries to store reports and other documents prior to consolidation. Additionally, users can manually load documents into these SharePoint document libraries for inclusion in the consolidated report packs. This mechanism allows variable and non-transactional data to be included, such as report commentaries and cover pages.

SQL Reporting Services Consolidator


Management

The definition of what is included in a consolidated report pack is controlled by a 'Report Pack Definition' xml file. These definition files define what reports and documents are included in the report packs but also, if reports are being collected on demand, what parameters are used to execute the reports. Finally, the report pack definition also controls the look and feel of the consolidated report pack by defining page orientation, paper size, sequencing etc.

 

Report Pack Definition Example
Click Image to Enlarge

 

If you would like to find out more information about Advanced 365’s Reporting Services Consolidator please contact us.


Advanced Business Solutions

Advanced Health & Care

Advanced 365

Advanced Computer Software plc

Advanced Computer Software Group
© Copyright Advanced 365 - All Rights Reserved 2011
Part of the Advanced Computer Software plc Group