HTML table

As an alternative to the previously described XML format you can display the result of your query in a formatted HTML table.

The URL is composed as follows.

Query pattern

http://host:port/kontextname/urlquery/html/query.do?parameterliste

Configuration and transferred parameter list are the same as described in chapters URL query and Submitting a query.

Formatting

You can customize selected display properties for the HTML table by adjusting various styles. The styles are saved in a document template and can be edited in the Report definition component of the PPM user interface.

Tip

For further information on editing a document template, please refer to the PPM online help.

The standard styles are saved in the document template _default_queryapi_html (file name: _default_queryapi_html.ret).

If you want to use a specific document template for representing your HTML table you can specify the name of that template in the optional URL argument reporttemplate. The document templates are saved in the directory config\<client name>\report\reportdefinitions of your PPM installation.

Style for list tables

Style

Description

table-header

Specifies the appearance of the table's column headers

table-content

Specifies the appearance of the table's data cells

table-color-properties

The font color determines the color of the table borders and grids, and the background color determines the color of the table background.

Style for crosstabs

Style

Description

crosstable-header

Specifies the appearance of the upper left cell of the crosstab

crosstable-iteration-header

Specifies the appearance of the crosstab's iteration headers

crosstable-iteration-content

Specifies the appearance of the crosstab's iteration steps

crosstable-ki-content

Specifies the appearance of the measure names in the crosstab (if multiple measures are displayed)

crosstable-result-header

Specifies the appearance of the headers of sum rows and
columns in the crosstab

crosstable-result-content

Specifies the appearance of the content of sum rows and columns in the crosstab

crosstable-content

Specifies the appearance of the crosstab's measure values

table-color-properties

The font color determines the color of the table borders and grids, and the background color determines the color of the table background.

The selected background color determines the background color of the corresponding table cells in all styles (except for table-color-properties).