Reporting Software - Miscellaneous Report Properties

Property

Description

format.time

Format used for all time data (Date).

format.date

Format used for all date data. .

format.number.round

If a number format is not specified in the designer, this property value controls the rounding of the numbers. The property values are the same as the valid arguments for the 'formatNumber()' method.

string.compare.
caseSensitive

Default grouping and ordering is now case-insensitive, which is consistent with most databases. Set this property to true to revert to pre-9.1 behavior.

export.csv.delimiter

Delimiter used when exporting a CSV file.

export.csv.quote

Quote character used when exporting a CSV file.

export.text.table.
maxRowAlign

Set the number of rows to look at when determining the column width to use in Text exports.

export.Excel.isHeader
FooterInPageSetup

If “true,” top and bottom margins, and headers and footers will be set in Excel's “Page Setup”

excel.close.factor

For Excel export, a factor determining whether nearby report elements are placed in adjacent cells or spaced apart. A smaller factor creates more space between elements in the exported spreadsheet.

query.variable.unique

If query variables are declared as unique, variables with the same name across different queries are treated as one variable. Otherwise, each query contains its own set of variables.

exceed.session.page

Contains a path to an html file that contains a message to display when the maximum number of concurrent users has been exceeded. If this is not set, the default message is used.

jdbc.connection.pool

Class Name for a user defined connection pooling class. This class should implement inetsoft.uql.jdbc.ConnectionPool

jdbc.connection.pool.size

Initial size of the connection pool.

jdbc.connection.pool.
maxsize

Max size to which the connection pool will grow, if required.

jdbc.max.cursor

Maximum number of cursors allowed per database connection. It may be necessary to set this property to 1 if an Oracle database is observed to execute queries sequentially rather than concurrently.

db.caseSensitive

Indicates (when set to true) that database column names have been defined in the database software as case-sensitive.

sree.bundle

The name of the report localization bundle.

index.directory

The directory where this software stores indexed data that is used for searching the archive.

fiscal.start.month

The month in which the fiscal year begins.

fiscal.start.day

The day in the fiscal.start.month on which the fiscal year begins.

default.browser

This defines the default browser used on Unix machines. It defaults to Mozilla.

barcode.bar.width

The width (in pixels) of the thinnest bar in a barcode. Other bars will change their size relative to this.

barcode.resolution

The output resolution of the barcode when either the barcode is being outputted to a device other than the screen, or the barcode is being generated on a headless machine and the screen resolution could not be determined. The default resolution is 72 dpi.

text.encoding.utf8

By default it is set to true. If this property is false, you will use the encoding specified for the local operating system instead of the UTF8 encoding.

map.shp.dir

Property to specify the absolute path of the folder which contains the .shp and .jar files used by the map element.

script.execution.timeout

A safety-net for script execution time, especially for infinite loops. Times-out the script if execution time exceeds specified value (in seconds).

olap.table.
originalContent

Set to 'true' (default) to display the value of a CUBE dimension with all its hierarchical components, else set to 'false. (Applies to table headers, chart labels, and selection lists.)

olap.drillthrough.
maxrows

Determines how many rows to display for a Show Details operation against an OLAP cube.

olap.table.maxrow

Determines how many rows to retrieve when creating unique values for selection lists.

anonymous.userdata.save

Set to 'false' to prevent storage of preferences for the anonymous user.

remove.outerJoin.only

When 'false', the query engine removes joined tables with no columns in the 'select' and 'where' clauses, such as when a condition is dropped due to null parameter.

help.url

URL (absolute or relative) of the parent directory of the '_HTMLDoc.htm' file for end-user documentation.

help.dev.url

URL (absolute or relative) of the parent directory of the '_HTMLDoc.htm' file for developer documentation.