Attributes Reference

Last updated
Save as PDF

You can click on any element, and the composition of the Attributes pane will adjust to show the ways it can be customized. Not all properties will apply to every attribute.

You cannot edit any Style or Attributes options for any selected report elements in the workspace while the Data tab has focus. Click the Structure tab to see the Style and Attributes panes for selected elements.

All of the items in the Attributes pane are described in the following reference:

Barcode

The following attributes belong to the barcode property:

Attribute Name	Purpose	Values
bar-height	Sets the height of the bar code.	Integer of any value.
bar-width	Sets the width of the bar code.	Integer of any value.
checksum	Shows the checksum value.	Boolean; default is false.
type	Sets the type of bar code.	String; default is code128 (see Barbecue project documentation for details)
show-text	Displays text under the bar code.	Boolean; default is false.

Common

The following attributes belong to the common property:

Attribute Name	Purpose	Values
type	Defines the type of element.	Predefined and locked as an element type.
field-name	Defines the existing field to use.	String; there is no default, you must define a value manually.
value	Defines a hard coded value instead of a field.	String or integer; no default value.
group-fields	Defines the field to group by.	String or integer; no default value.
resource-value	A resource string found within the resource bundle.	String; no default value.
resource-identifier	Defines the file that contains resource strings.	String; no default. This is a properties file, including the path.
name	The name you want to assign to this element.	String; no default value.
output-format	Sets preferred output type for the report.	String; no default value. Possible values are: html, pdf, xls, rtf, csv, xml.
lock-output-format	Locks the output type specified in the output-format attribute so that no other output type can be chosen.	Boolean; default is false.
auto-submit	If selected, your parameterized reports will automatically update based on the current selection in your parameter lists. If un-checked, parameter selections will not automatically change the report data; report users will have to select a new parameter value and then click View Report to update the report.	Boolean; default is false.
format	Sets the Java format string.	String; there is no default. Must be in the Java number or date format.
if-null	If the defined field or value returns null, show the value defined here.	Boolean; default value is false.
message-null-value	If the message returns null, then return the value defined here.	String; no default value.
arc-height	Defines the arc (corner) height of a rectangle.	Integer; default value is 0.
arc-width	Defines the arc (corner) width of a rectangle.	Integer; default value is 0.
data-cache	Determines whether parameter result sets are cached, which would reduce the amount of reload time when switching parameters in a rendered report. This option can be further configured through the org.pentaho.reporting.engine.classic. core.cache.InMemoryCache.CachableRowLimit and org.pentaho.reporting.engine.classic. core.cache.InMemoryCache.MaxEntries engine settings.	Boolean; default is True (cache is turned on).

The following attributes belong to the table-of-contents property:

Attribute Name	Purpose	Values
group-fields	Defines both the depth of the data-collection and the fields from which to read the group-value-X values.	If the group-field given in the array is empty, the field value will be read from the current relational group and in the details-processing, the value will be null. If the group-fields list is empty, an automatic mode is activated that collects all groups extracting the group-value from the relational group.
title-field	Defines a field in the master-report that will be read for a valid item-title.	Any column field or function
title-formula	Defines a formula that is evaluated when a new item has been collected. The formula will only be evaluated if the title-field is not set.	Formula
collect-details	Defines, whether detail items should be included in the data-collection.	Boolean; default is false. This attribute consumes a significant amount of system memory. Do not use this attribute on reports that are over a million rows.
index-separator	Defines the separator text that is used between the index-elements.	String; default is comma (,).

Index

The following attributes belong to the index property:

Attribute Name	Purpose	Values
data-field	Defines the field to be used as the item-data or item-key.	Any column field or function
data-formula	Defines an open formula to be used as the item-data or item-key.	Formula Important: Make sure that data-field is not defined, if this attribute is used.
index-separator	Defines the separator text that is used between page numbers in the item-pages field in the index sub report. It defaults to ",".	String; default is comma (,).
condensed-style	Defines whether or not a dash (-) is used between continuous page numbers; for example, 4,5,6,7 display as 4-7.	Boolean; default is false.

Excel

The following attributes belong to the excel property:

Attribute Name	Purpose	Values
formula	Converts an entered value or formula into a Excel numeric value.	String; no default value.
page-header-text	Appends text into Excel page header.	String; no default value.
page-footer-text	Appends text into Excel page footer.	String; no default value.

HTML

The following attributes belong to the html property:

Attribute Name	Purpose	Values
append-header	Inserts the HTML entered here into the <header> of the HTML output.	String; no default value.
append-body	Inserts the HTML entered here into the <body> of the HTML output.	String; no default value.
append-body-footer	Inserts the HTML entered here into the <footer> of the HTML output.	String; no default value.
alt-name	Defines the text for the HTML <img> tag's alt attribute.	String; no default value.

HTML-Events

The following attributes belong to the html-events property:

Attribute Name	Purpose	Values
class	Defines the value to insert into the HTML <class> tag.	String; no default value.
name	Defines value for the name HTML object attribute.	String; no default value.
title	Defines the value to insert into the HTML <title> tag.	String; no default value.
xml-id	Defines value to insert into the HTML <xml-id> tag.	String; no default value.
on-click	Defines value for the onclick HTML DOM event object property.	String; no default value.
double-click	Defines value for the doubleclick HTML DOM event object property.	String; no default value.
on-mouse-down	Defines value for the onmousedown HTML DOM event object property.	String; no default value.
on-mouse-up	Defines value for the onmouseup HTML DOM event object property.	String; no default value.
on-mouse-move	Defines value for the onmousemove HTML DOM event object property.	String; no default value.
on-mouse-over	Defines value for the onmouseover HTML DOM event object property.	String; no default value.
on-key-down	Defines value for the onkeydown HTML DOM event object property.	String; no default value.
on-key-pressed	Defines value for the onkeypress HTML DOM event object property.	String; no default value.
on-key-up	Defines value for the onkeyup HTML DOM event object property.	String; no default value.

Images

The following attributes belong to the images property:

Attribute Name	Purpose	Values
image-encode-quality	Controls the JPEG encoding quality	A decimal percentage value between 0 and 1. The closer to 1, the higher the quality and larger the file size.
image-encode-type	Determines the image format of PDF and HTML graphics.	Possible values are: .jpg and .png. Default is .png.

PDF

The following attributes belong to the pdf property:

Attribute Name	Purpose	Values
script	References a script name inside the PDF.	String; no default value.

Pentaho

The following attributes belong to the pentaho property:

This list is incomplete.

Attribute Name	Purpose	Values
report-cache	Determines whether parameterized reports published to the Pentaho Server are cached on a per-session basis, which would reduce the amount of reload time when switching parameters in a rendered report.	Boolean; default is True (cache is turned on).

Query

The following attributes belong to the query property:

Attribute Name	Purpose	Values
name	Assigns a name to the selected query. If you are using a JDBC Custom data source, you can type the entire query directly into the name field.	String; no default value.
row-limit	Row limit for the query.	Integer; default value is -1, meaning there is no hard limit.
time-out	Timeout limit for the query.	Integer; default value is 0, meaning there is no timeout.
design-time-out	Timeout limit when running from Report Designer.	Integer; default value is 0, meaning there is no timeout.

Query-Metadata

The following attributes belong to the query-metadata property:

Attribute Name	Purpose	Values
data-format	Use the number or date formatting from the Report Design Wizard or the data source.	Boolean; default is true if you are using the wizard, false if you are not.
style-format	Use the style formatting from the Report Design Wizard or the data source.	Boolean; default is true if you are using the wizard, false if you are not.

Parameter

The following attributes belong to the parameter property:

Attribute Name	Data Type	Definition/Values
auto-submit	Boolean	Determines whether the report uses the parameter interface in the Pentaho User Console (PUC) when it runs. The values are: True: When set to True, the report runs when any control is updated in the parameter interface. False: When set to False, the report does not run when a control is updated in the parameter interface. The report runs when you select the Update button. <undefined> (Default). When set to undefined, the auto-submit checkbox displays in the parameter interface so you can control when you want to use the option. The initial state of the checkbox is determined by the auto-submit-default attribute.
auto-submit-default	Boolean	Sets the state of the auto submit checkbox on the parameter interface. The values are: True: When set to True or undefined, the auto submit checkbox is enabled. False (Default): When set to False, the auto submit check box is disabled. <undefined> When set to True or <undefined>, the auto submit checkbox is enabled.
parameter-layout	Selection	Sets the parameter display in PUC. The values are: The vertical value adds each selection control into separate rows (Default). The horizontal value adds each selection control into the same row. The flow value adds each selection control into the same row and wraps them when space is limited.
show-parameter-ui	Boolean	Determines whether the parameter interface will display in PUC. The values are: True: When set to True, the parameter interface displays. False (Default). When set to False, the parameter interface does not display.

Sparkline

The following attributes belong to the sparkline property:

Attribute Name	Purpose	Values
spacing	Sets the spacing (in pixels) between bars for a bar sparkline.	Integer; default is 0.
start-angle	Sets the start angle (in degrees) on a pie sparkline.	Integer; possible values are from 1 to 360. Default is 1.
counter-clockwise	Sets the plot direction on a pie sparkline.	Boolean; default is false, which represents clockwise.
high-slice	Sets the hexadecimal color for the high slice.	String; there is no default, you must define it manually.
medium-slice	Sets the hexadecimal color for the medium slice.	String; there is no default, you must define it manually.
low-slice	Sets the hexadecimal color for the low slice.	String; there is no default, you must define it manually.

Survey-Scale

The following attributes belong to the survey-scale property:

Attribute Name	Purpose	Values
highest	Sets the scale max value.	Integer; default is 5.
lowest	Sets the scale min value.	Integer; default is 1.
range-upper	Sets the bar plot max value.	Integer; default is not defined.
range-lower	Sets the bar plot min value.	Integer; default is not defined.

Swing

The following attributes belong to the swing property:

Attribute Name	Purpose	Values
action	Defines the Java method.	String; default is not defined.
tooltip	Defines the content of the tooltip.	String; default is not defined.

Wizard

The following attributes belong to the wizard property:

Attribute Name	Purpose	Values
wizard-enabled	If enabled, clears out all bands affected by the generated-content-marker attribute and starts from scratch.	Boolean; default is true.
aggregation-group	Defines the group name to aggregate by.	String; default is not defined.
aggregation-type	Defines the function to use to aggregate the field.	String; default is not defined.
generated-content-marker	Marks the band that you want to insert the wizard's generated content into.	Boolean; default is false.
grid-color	Defines the hexadecimal border color of the selected element in the Details band.	String; default is not defined.
grid-style	Defines the border style of the selected element in the Details band.	String; default is not defined. Possible values are: solid, dashed, dot-dash, dot-dot-dash, dotted, double, hidden, none, groove, ridge, inset, outset.
grid-width	Defines the border width (in pixels) of the selected element in the Details band.	Integer; default is not defined.
label-detail-header	Defines the Detail band header.	String; default is the selected field name.
only-show-changing-value	Controls whether the field repeats in the Details band.	Boolean; default is false.