Your location:Home>News Center >Industry News

Query Reporter: an easy-to-use tool to create and run HTML reports

发布时间:2018/06/13 浏览量:210
Query Reporter Query Reporter is an easy-to-use toolto create and run HTML reports from the results of a SQL query aga...

Query Reporter


Query Reporter is an easy-to-use 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, backround, margins and so on.


Major Query Reporter features

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.

SQL Editor
  The SQL editor uses syntax highlighting to improve readability of the SQL   text, and to quickly verify if your SQL syntax is correct. In case of an SQL   syntax error, the cursor will be located on the error position.

PL/SQL Developer report compatibility
  Query Reporter uses the same report definition file format asPL/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.

Command-line interface
  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. For example:
    QueryReporter userid=scott/tiger@chicago exec=DeptEmp.rep   html=DeptEmp.html quit

  You can create reports that need to be run under privileged accounts, without   providing the password to the end-user. You can for example define a report   for the SYS account, and include the SYS password in the encrypted report   definition file. You can only view or modify the report definition if you   have the SYS password.

Export features
  The query results of a report can be exported to HTML, XML, CSV or TSV   format. You can alternatively show the results directly in a Microsoft Excel   spreadsheet.

System requirements
  Query Reporter will run on Windows 95, 98, ME, NT4, 2000, XP, 2003, 2008,   Vista, Windows 7, Windows 8 and Windows 10. The supported Oracle Server   versions are 7.x, 8.x, 8i, 9i, 10g, 11g and 12c on any platform. To connect   to an Oracle database, the 32 bit Query Reporter version requires a 32 bit   Oracle Client and the 64 bit Query Reporter version requires a 64 bit Oracle   Client.

下一篇:WijmoJS: 新一代 JavaScript控件 | 采用最in最酷的技术,快如闪电、操作更灵活!
上一篇:Xshell: 强大的安全终端仿真软件(二)| HSM增加安全性,双字体集成适应不同语言需求

© Copyright 2000-2019  COGITO SOFTWARE CO.,LTD. All rights reserved