The challenge for this organization was to deliver reports to a diverse, mostly low-tech audience spread around the country, and to do so with a minimum of training. Another requirement was to create an application that fit into their existing suite of applications from a look-and-feel standpoint. And another requirement was the ability to have dynamic parameter pick lists.
The application was created using CSP and the COM SDK. The dynamic parameter pick lists were created using a custom database and administration program that allowed administrators to specify SQL queries to produce the pick lists.