End to end reporting solution, from data warehouse design through to SharePoint integration
Customer: Diagnostic Imaging Provider
Project: End to end reporting solution, from data warehouse design through to SharePoint integration.
Pursuit Technology were responsible for enabling reporting across multiple disparate systems. A reporting database (datamart) was designed in Microsoft SQL Server, loaded on a daily basis using Microsoft SQL Server Integration Services. The reports were initially intended to be produced on a monthly basis. However, this soon changed to daily once the business benefits became clear.
For report generation, Crystal Reports Server was used with custom code produced by Pursuit Technology enabling reports to be viewed from the company’s SharePoint site. By using custom code rather than the normal SharePoint integration, a modified view of the report list could be produced to simplify report consumption. In addition, the Crystal Server licenses could be less easily managed to avoid all the problems associated with users holding a license when they fail to logout.
Technologies:
- Crystal Reports Server
- Crystal Reports
- Microsoft SQL Server
- Microsoft SQL Server Integration Services
- Microsoft SharePoint
- Visual Studio
- C#, aspx