The Problem:  Main report is printed and emailed to staff who manually extract data into customized reports.

Reports are generally outdated and inconsistent based on when people extract information and from which version of the main report they use.  The result is often conflicting final reports which require another step of data verification before the reports can be published which is done by visually comparing the data in hard copy, side by side.  This is not a good utilization of staff time.

The Solution: Report extracts done in real time using a relational database housing the main report.  This allows queries to create the required ad-hoc reports and eliminates the need for data verification.

A relational database was created which allowed queries on the needed fields to extract data real time.  The database was placed on the server where users could hot sync the latest version to their PDA for further analysis.