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. |
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. |
Set the number of rows to look at when determining the column width to use in Text exports. |
export.Excel.isHeader |
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. |
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. |
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. |
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 >> |