Challenge

The customer required a highly maintainable web-application that would allow agents to enter incident information into a Microsoft SQL database. From this data, customizable reports should be generated for output to Excel. All agent-administration and content management would maintainable within an admistration application. The reporting system would have to be able to represent any crossection of the dataset in n-dimensions and sorting. The system would have to be integrated with microsofts domain-server authentication system.

Solution

This project is one of the many applications an agent has to work with, so keeping the application easy to use and simple to learn was one of the key goals in the process. For this our developers chose to created an application that looks very similar to standard Desktop Visual Basic applications.

This allowed a lot of different items and choices to be represented in a simple and low-learning curve interface. The Management interface was created in a similiar fashion, allowing administrators to control agent user rights managment and control over picklists data and other content-mangement services. The most unique feature of this solution is quite likely the reporting engine. For this project we used the Javeline Declarative Reporting solution. (An XML Declarative OLAP-Cube processor in ASP.NET). This means that to create a highly complex report with lots of calculated fields and sliced out in many dimensions, all that is required is a short declarative definition to create this report. This solution allows the client to very easily create any type of reporting output management requires, and can be fully managed by the client itself.