B.13 Miscellaneous Properties

The following table lists a variety of other properties.

Property

Description

format.time

Format used for all time data (Date). See Formatting in the Report Design for more information.

format.date

Format used for all date data. See Formatting in the Report Design for more information.

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. See Global Functions for more details.

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.

excel.colwidth.max

For export to Excel (best data editing), specifies the maximum permitted Excel column width. If the report element width exceeds the maximum, it is represented in Excel by merging multiple columns with widths given by excel.colwidth.normal.

excel.colwidth.normal

For export to Excel (best data editing), specifies the column width to use for merged columns when a report element's width exceeds excel.colwidth.max. A value of -1 indicates that no merging should be performed.

excel.rowheight.max

For export to Excel (best data editing), specifies the maximum permitted Excel row height. If the report element height exceeds the maximum, it is represented in Excel by merging multiple rows with heights given by excel.rowheight.normal.

excel.rowheight.normal

For export to Excel (best data editing), specifies the row height to use for merged rows when a report element's height exceeds excel.rowheight.max. A value of -1 indicates that no merging should be performed.

excel.font.ratio

Sets the proportion by which font size is globally reduced for Excel exports. (Font size reduction can often improve the appearance of Excel exports.) For example, setting excel.font.ratio=0.85 uniformly reduces font sizes within the exported report to 85% of their size in the original report. To set this proportion on a font-by-font basis, use the property template excel.font.<fontname>.ratio, e.g., excel.font.arial.ratio=0.80.

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. Default is 15.

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. Default for Oracle is 300, and for other databases is 1.

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. Default is 10.

olap.table.maxrow

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

olap.cancel.enabled

Set to 'true' (default) to enable query cancellation for OLAP databases. This feature cancels currently executing queries when a user makes updates to their selections. Set to 'false' to prevent errors on databases that do not support query cancellation.

anonymous.userdata.save

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

login.loginAs

Set to 'on' to permit an administrator to log in as a particular user. (Adds a 'Login as' field to the Portal login screen.) See Emulating a User Login.

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. See Configuring User and Developer Help.

help.dev.url

URL (absolute or relative) of the parent directory of the '_HTMLDoc.htm' file for developer documentation. See Configuring User and Developer Help.

<< B.12 Archive Properties © 1996-2013 InetSoft Technology Corporation (v11.4) Appendix C: Manually Deploying a WAR File >>