Large Corporate Wide Business Reporting Application using ASP.NET Web Services and Win Forms
Requiring a rich desktop application with almost 'psychic' capabilities (rapid keystroke entries,
multiple tabbed interfaces, wizards etc.), our team stepped up to the task and delivered a quality
desktop application.
The Challenge
- To automate various paper-driven processes and internal operations.
- To generate professional looking reports containing past revenues and projected revenues. Each of these reports could be on a per-client basis or a per time-period basis or a combination of additional parameters.
-
The insurance industry is a heavily paper-driven industry - involving a wide variety of forms, applications and paper-based products.
- Rich forms requiring rapid keystroke entries, highly customized validation rules, multiple tabbed interfaces, wizards etc.
-
With insurance data spread across various databases and various time periods - it became a challenge to retrieve certain specific business
centric data - such as monthly total claims, annual premiums etc.
-
Reports would need to be created ad-hoc - by a super-user - who could ideally pick and choose the database fields that were needed on the new
report - and could also schedule the execution of the report.
The Solution
- Rich Client Interface
A comprehensive set of Windows Forms (WinForms)
including sophisticated user controls, custom validation, multiple tabbed interfaces and rapid keystroke entries was designed
and built to match the paper based forms.
-
Corporate-wide reporting
Leveraging .NET's built-in support for Crystal Reports, ANUJ Technologies helped build a highly customizable reporting application. The actual implementation consisted of creating
customized 'report creation' forms which let an end-user input specific 'report parameters' and their corresponding values (e.g. start date, end date).
These parameters were used to dynamically set values on a pre-defined template (crystal report) - which was then executed against a Crystal Engine.
The result-set returned by the execution was provided in various formats including acrobat, excel - or (optionally) directly sent to a printer.
-
Automation of paper-driven processes
Each 'paper-centric' use case was analyzed with the objective of automating it - using a web-centric solution. The end-user would be required to simply
initiate each process via a website - which would also provide electronic versions of documents - as well as document specific artifacts (e.g. electronic signatures etc.)
Using .NET SOAP - a series of web-services was designed based on the set of use cases.
- Automated Builds and Deployments
Production releases were built using an automated build process involving picking up checked-in source files, modifying environment specific configuration files and building all project components.