• At global level (in jasperreports.properties) to provide a default value.
• At report level, to indicate whether element overlap checks are to be performed for the report. If not set, the global property value is used.
• At report element level to specify that the particular element is allowed to overlap or be overlapped by other elements, when the report or global property determines report element overlap verification. The element level property is only effective when set to true; setting the property to false does not make the verifier check for overlaps when the report is not set to be checked for element overlaps.

• TYPE_CROSSTAB_HEADER
• TYPE_COLUMN_HEADER
• TYPE_ROW_HEADER
• TYPE_DATA
• TYPE_NO_DATA_CELL

The property dictates what happens when a filled report contains an anchor having a bookmark level that is not the immediate successor of its parent (e.g. an anchor with bookmark level 3 follows immediately after a bookmark of level 1). If the property is not set, an empty bookmark is created for the missing level(s) in order to preserve the original level of the bookmark. When the property is set, the level of the bookmark will be collapsed and the bookmark will be created as a direct descendant of its nearest parent.

1. To have a single property for each sheet name:
   
   <property name="net.sf.jasperreports.export.xls.sheet.names.sheet1" value="First sheet" />
<property name="net.sf.jasperreports.export.xls.sheet.names.second.sheet.name" value="Second sheet" />
<property name="net.sf.jasperreports.export.xls.sheet.names.3" value="Third sheet" />
   
   Then, the 3 resulting sheets will be named as follows:
   
   First sheet
   Second sheet
   Third sheet
   
   
2. To have a single property containing all sheet names, separated by the "/" separator:
   
   <property name="net.sf.jasperreports.export.xls.sheet.names.all" value="First sheet/Second sheet/Third sheet" />
   
   Then, the 3 resulting sheets will be named as follows:
   
   First sheet
   Second sheet
   Third sheet
   The order is very important, as shown above.
   
   
3. To have any combination of 1) and 2):
   
   <property name="net.sf.jasperreports.export.xls.sheet.names.first" value="First sheet" />
<property name="net.sf.jasperreports.export.xls.sheet.names.others" value="Second sheet/Third sheet" />
   
   Then, the 3 resulting sheets will be named as follows:
   
   First sheet
   Second sheet
   Third sheet

• list - the query will be run by calling org.hibernate.Query.list()
• iterate - the query will be run by calling org.hibernate.Query.iterate()
• scroll - the query will be run by calling org.hibernate.Query.scroll()

• readOnly - the concurrency mode for a ResultSet object that may NOT be updated.
• updatable - the concurrency mode for a ResultSet object that may be updated.

• hold - indicates that ResultSet objects should not be closed when the method Connection.commit() is called.
• close - indicates that ResultSet objects should be closed when the method Connection.commit() is called.

• forwardOnly - the cursor may move only forward.
• scrollInsensitive - the result set is scrollable but generally not sensitive to changes made by others.
• scrollSensitive - the result set is scrollable and generally sensitive to changes made by others.