This was our second Web Based project. Exxon required a series of Financial Reports which would allow for "drill-down" and "drill-up" abilities with all data for these reports coming from an internal MsSql database.

What I mean by "Drill-Down" report is the ability to start at the Highest Level possible. For example you might select an annual company wide financial report. Starting there you had the ability to simply click a link and you would go to the next level down, possibly a quarterly report. Or you could click a different link and see the data broken down by District. You had the ability to continue to "drill-down" until you were at a daily or retail location level.

The amount of detail seen for each report of course depended on the type of financial report you were looking at. It could be a report on Sales by location or Sales by time period.

There were a total of 4 types of reports each with the ability to go from very general to very detailed.

This sort of thing today is pretty common but back in 1996 it was all new. Most Financial reports at that time came from Main Frame computers and anything new could take if you were lucky a few days and more commonly a week or more. The reports were never interactive as they were printed reports and if you remember the "old days" very cumbersome to use compared to the technology we have today.

Another challenging and interesting Project. Exxon was very pleased with the results.