Export to HTML

Exporting to HTML can be a useful way of displaying your data:

it can be a simple way of sending the result of a query to another member of your workgroup, especially if they do not have AQT or other data formatting tool on their PC
it provides an alternate mechanism for printing your data

export_html

HTML Options

These options are on the HTML tab of the Export Options window.

Most of these options are related to the formatting of the HTML file generated by AQT. The options should be familiar to users familiar with HTML.

AQT uses styles for formatting the data in the cells of the HTML table. You have the choice of where AQT writes the style information:

inline. AQT will write the style information as part of the export file
write to css file. When this option is selected, AQT will write the style information to a css (cascading style sheet) file. The export file will then reference this css file
use existing css file. In this case, AQT will not write a css file; instead it will reference one you have supplied. This option would be useful if you wish to apply your own styles to the file AQT generates

It is recommended that the css file resides in the same directory as the export file. If it is not, AQT will use a fully-qualifed name for the css file in the HTML file - this can cause problems with some web browsers.

The AQT export file uses four styles:

background. This is the area outside the table containing the exported data. It will apply to the Title plus the Write Text Before / After text.
heading. This applies to the heading row of the HTML table containing the Column Names

odd / even rows. AQT uses separate styles for odd and even rows in the HTML table. This enables you to use a two-color display for the results.

Exporting LOBs

If your data has LOBs (such as images) AQT can export these to separate files and create hyperlinks to them. See Exporting LOBs for more on this.

Hyperlinks

If AQT sees that a column value starts with http:// or https:// it will assume that this is a url and will create a hyperlink to that address.

Advanced Query Tool

https://www.querytool.com