Query Reporter - News

February 26, 2016 - 64 bit version released
The 64 bit Query Reporter can be used with the 64 bit Oracle Client.
July 24, 2015 - Version 3.4.0 released
  • Compatible with PL/SQL Developer 11.0:
    • Multi-select substitution variables
    • Lowercase substitution variables
    • Lines=<n> and editor=yes/xml/sql substitution variable options
  • Support added for Oracle12c extended strings (> 4000 bytes)
November 29, 2011 - Version 3.3.1 released
  • Breaks did not work on field names with international characters
  • Setup program improved
October 13, 2011 - Version 3.3.0 released
  • Compatible with PL/SQL Developer 9.0
  • Support for Excel 2007/2010
    • Parameter EXCEL2007
    • Parameter EXCEL <filename.xlsx>
    • Export (.xlsx) export option
  • Break did not always generate sum
April 2, 2010 - Version 3.2.1 released
  • Subtotals were not always calculated correctly
  • The internal HTML Viewer is now used by default instead of the Internet Explorer engine for better printing compatibility
December 16, 2009 - Version 3.2.0 released
  • Compatible with PL/SQL Developer 8.0
  • Reports can now be saved in PDF format
  • External Authentication now works from the command-line by using the userid=/[@database] parameter
  • In Run-only mode, report layout and options can no longer be changed
June 22, 2007 - Version 3.1.0 released
  • Compatible with PL/SQL Developer 7.1
  • Unicode support
  • Graphics functionality added
  • OFS support
March 19, 2005 - Version 2.0.5 released
  • Compatible with PL/SQL Developer 6.0:
    • Read-only substitution variables added (readonly="yes")
    • Hidden substitution variables added (hidden="yes")
  • Auto refresh button and configuration added
  • Export to Excel performance improved
  • Runtime-only version available on request
  • Select-only version available on request
November 6, 2003 - Version 2.0.4 released
 Bugfixes and enhancements
  • International version: English, Japanese, German, French and Czech
  • If a report file is not found, the default report directory is searched
  • Text editor added for html and description items
  • PRINT parameter caused an "Unknown parameter" error
  • Fixed security issue when clearing a report
  • Background image files are now stored with a relative path
April 29, 2003 - Version 2.0.2 released
  • Subsequent && pairs (escaped substitution variable prefix) would be replaced by one &
  • && in substitution variable value would be replaced by &
  • Printing HTML with Internet Explorer viewer now without header, footer and with correct orientation
January 27, 2003 - Version 2.0.0 released
  • Export results to XML, CSV, TSV, or directly to Excel
  • System variables in report title (&dbuser, &database, ...)
  • Added Format option for number and date fields
  • SQL Text can be included in the HTML output
June 22, 2002 - Version 1.1.0 released
 Bugfixes and enhancements
  • Page break added
  • New break option: Break + Header
  • Sum at break/report level added
  • Non breaking space option added
  • Fixed multibyte character set bug causing ORA-01026
April 2002 - Version 1.0.0 released
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, headers, backround, margins and so on.

Query Reporter uses the same report definition file format as PL/SQL Developer. Therefore you can use Query Reporter to run reports created by PL/SQL Developer users, without needing a PL/SQL Developer license or installation.

Furthermore you can use Query Reporter's command-line interface to run reports without any user-interaction, and to save the result in an HTML file. These result files can be viewed with any Web Browser.