Applications‎ > ‎

Desktop Ad-hoc Reporting

Overview


The Database Ad-hoc Reporting Tool, fondly known as the Infonet Query Tool, or IQT, was originally developed as a Visual Basic client application, connected to various Oracle databases using Oracle Objects for OLE. The VB version was later ported to an ASP.Net 2.0 application WIQT.

IQT transformed the accounting operations, as early as Oracle Financials Release 9, without a costly Business Intelligence reporting solution and is still in use today. What is unique about IQT is the flexibility represented in encapsulating any SQL command with user defined input selection criteria.
Report Selection and Input Criteria

The types and variety of reports are shown on the left-hand selection/navigation panel. IQT was used across all the Oracle RDBMS based applications and became the standard for user reporting access. The key was defining the Sql*Net connection to the proper Oracle database and importing a SQL query as select columns, from tables and join conditions. These were represented internally in set of report and column classes. Through IQT, the query was represented as an easy-to-use, familiar user input selection and a convenient mechanism to run the report.

For each report, the user defined selection criteria are shown on the right-hand panel. Selection options included single value, multiple values, ranges, wildcards or combinations of all the selection types. In addition, the report could be detail or summary.


Advanced SQL Selection


As IQT became the user reporting tool of choice, on a few occasions, it was necessary to setup more complex user defined columns and SQL where clauses. The advanced SQL Selection panel provided the input for both. This also supported more complicated boolean logic with multiple and and/or conditions.


Report Output


One of the nice features of IQT was the ability to provide subtotals and totals, and the ability to export to Excel, CSV, TXT file format. Here is an example of a report output with subtotals/totals.


IQT was one of the few applications that I felt was complete, without wanting to rework. The web version provided very nice internal class structures and dynamic sql construction, along with the use of ASP.Net user controls for a very modular design. IQT changed the way the business community worked with the data from their Oracle databases.