Melton Information Services Limited
Connection to a wide variety of databases including ADO/ODBC, ORACLE, Firebird, and Advantage Database.
The sophisticated visual query builder is provided by Active Database Software (http://www.activequerybuilder.com/index.html) and is able to represent sub-queries and unions. It is bidirectional: if the user builds a visual model, then the query builder will generate the correct dialect of SQL; if the user provides SQL, then the query builder will reverse-engineer it into a visual diagram.
The software presents syntax-highlighted SQL, and provides for parameters to be used.
The software provides access to the popular report generator Fast Reports (http://www.fast-report.com/en/). Fast Reports itself provides export of the results to a variety of useful formats.
Output can be generated as a sophisticated pivot table: FastCube from (http://www.fast-report.com/en/). This can be exported into a number of formats, and can also be circulated in a form which permits end-user manipulation.
Output can be directed to a chart for display and printing.
Results from executing the query can be exported as txt, csv, or xls.
All the instructions relating to the above features are stored in a Project Script file (mrf) which can be circulated to other users and executed by those with no technical knowledge.
The software provides for query results to be output in a wide variety of formats.