Problem

Multiple stock reports showed the same variables with different values for the same quantities. In addition
to this there was ambiguity with variable names and the reports often ran very slowly. Some reports caused
server slow downs. Because the code was not built into a framework minor changes could take hours. Multiple
versions of database jobs created a situation where excel exported values often disagreed with displayed values.

Action

In phase one an analysis of the reports was done. Agreement was reached on the names and definitions of all the
reported values, code was optimized and standardized and bugs were fixed.

In phase two a complete reporting frame work was designed and implemented to facilitate the creation of and
standardization of reports. To this frame work was added key stock reports. The framework was added to many
client applications as a standard module.

Solution

The standardization of reporting within a frame work made adding reports a snap. Reports with stock filters
view , print and data export can be created very rapidly and the code is easy to follow and edit.
Greater consistency is enforced given the constraints of the design. Fewer calls about reporting bugs
free up time on the support queue. Disambiguation and standardized reported values makes for easy understanding
by users and trainers.