Query Reporter is an easy-to-use freeware tool to create and run HTML reports from the results of a SQL query against an Oracle database. From a simple query, you can define tabular, break, and master/detail reports. You can refine the layout by specifying colors, fonts, alignment, formats, sums, headers, background, margins and so on.

Features

Main Application Window

Query Reporter provides a simple Single Document Interface to create or run your reports. In the top section you can define the SQL statement, Layout properties, and Options. In the bottom section you see the report results, which can be saved to an HTML file, or copied to the clipboard.

Powerful substitution variables

You can use substitution variables in the SQL text where input from the end-user is required. You can define if these substitution variables are string, number or date values, if they should be represented as selection lists or checkboxes, what the default value is, and so on.

Graphical Query Builder

The graphical Query Builder makes it easy to create new select statements or modify existing ones. Just drag and drop tables and views, select columns for the field list, where clause and order by clause, join tables based on foreign key constraint definitions, and you’re done.