Previous Page Next Page
The properties of a group header panel object in a banded object are as follows.
| General | ||
|---|---|---|
| Data Inherit | Indicates whether the dataset for this object is inherited from another object. This property is read only. | |
| Display Name | Specifies the display name of the object.
Data type: String |
|
| Instance Name | Shows the instance name of the object. This property is read only. | |
| Geometry | ||
| Height | Specifies the height of the object. Enter a numeric value to change the height.
Data type: Float |
|
| Width | Specifies the width of the object. Enter a numeric value to change the width.
Data type: Float |
|
| Color | ||
| Background | Specifies the background color and fill effect of the object. Choose a color from the drop-down list or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String |
|
| Border | ||
| Border Color | Specifies the color of the border of the object. Choose a color from the drop-down list or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String |
|
| Border Thickness | Specifies the width of the border. Enter a numeric value to change the thickness.
Data type: Float |
|
| Bottom Line | Specifies the line style of the bottom border of the object. Choose a style from the drop-down list.
Data type: Enumeration |
|
| Left Line | Specifies the line style of the left border of the object. Choose a style from the drop-down list.
Data type: Enumeration |
|
| Right Line | Specifies the line style of the right border of the object. Choose a style from the drop-down list.
Data type: Enumeration |
|
| Top Line | Specifies the line style of the top border of the object. Choose a style from the drop-down list.
Data type: Enumeration |
|
| Others | ||
| Cross Page | Specifies whether the panel can be split across a page break. This property is applied only when the report has page layout enabled.
Data type: Boolean |
|
| Export to CSV | Specifies whether to include the object in the CSV result of the report.
Data type: Boolean | |
| Export to Excel | Specifies whether to include the object in the Excel result of the report.
Data type: Boolean | |
| Export to HTML | Specifies whether to include the object in the HTML result of the report.
Data type: Boolean | |
| Export to PDF | Specifies whether to include the object in the PDF result of the report.
Data type: Boolean | |
| Export to PostScript | Specifies whether to include the object in the PostScript result of the report.
Data type: Boolean | |
| Export to Report Result | Specifies whether to include the object when running the report in Web Report Studio.
Data type: Boolean | |
| Export to RTF | Specifies whether to include the object in the RTF result of the report.
Data type: Boolean | |
| Export to Text | Specifies whether to include the object in the Text result of the report.
Data type: Boolean | |
| Export to XML | Specifies whether to include the object in the XML result of the report.
Data type: Boolean | |
| Fill Whole Page | Specifies whether to make the panel extended to the bottom of the page, so that the next panel starts on a new page.
Data type: Boolean |
|
| Invisible | Specifies whether to show the object in the report. All formulas and calculations will still be performed if the property is set to true. You can also use a formula to control whether or not to show the object.
Data type: Boolean |
|
| Label | Specifies the popup text displayed when the mouse pointer hovers over the left edge of the panel.
Data type: String |
|
| Merge to Next Panel | Specifies whether to merge the panel into the next panel in the exported Excel file.
Data type: Boolean |
|
| On New Page | Specifies whether the panel starts on a new page. This property is only applied if the report has page layout enabled. The default is false which means the panel starts on a new page only if the previous page is filled.
Data type: Boolean |
|
| Record Location | Specifies the calculation point for the properties which use formulas. Choose an option from the drop-down list.
Data type: Enumeration |
|
| Remove Blank Row | Specifies whether to remove blank rows in the panel in the exported Excel file.
Data type: Boolean |
|
| Repeat | Specifies whether to make the group header appear in every page.
Data type: Boolean |
|
| Repeat in Detail Panel | Specifies whether to make the objects in the panel repeated in the detail panel in the exported Excel file.
Data type: Boolean |
|
| Suppress | Specifies whether to show the object in the report. All formulas and calculations will be skipped if the property is set to true.
Data type: Boolean Note: When both the Invisible and Suppress properties of an object are set to true, Suppress has the higher priority. |
|
| Suppress Blank Panel | Specifies whether a panel with no data is included in the report. The default is false which means an empty panel is shown.
Data type: Boolean |
|
| Suppress When No Records | Specifies whether to display the object in the report when no record is returned to its parent data component.
Data type: Boolean |
|
| Underlay | Specifies whether the panel will be layered beneath the next panel in the banded object. A panel layered beneath a subsequent panel can be used to contain a background picture or watermark. Banded page header, page footer, or group footer panels cannot be layered. The default is false which means that the panel is not layered beneath the next panel.
Data type: Boolean |
|
For one detail panel which spans a large space vertically and cannot be wholly shown in a page, it will be shown in the next page if this property is set to false. If it is set to true, this panel will be split across a page break when it exceeds the page height.
If you want each group to start on a new page, you have two approaches. One is to configure with group header panel as follows, the other is to set the Fill Whole Page property for the group footer panel.
There is a problem when you only set On New Page to be true for the group header panel. You will find that the first page will have no details. JREngine starts the detail panel from the second page. To solve this issue, use a formula to control this property. The formula will judge the property as being false for the first group, and being true for subsequent groups for displaying on a new page. You will need to write three formulas and you will also learn how to control property value with a formula. However, if you feel this is too complicated, go to the group footer panel for the second approach.
global:
global integer i=0;
groupHD:
i=i+1;0
FormulaControl:
@groupHD;
if (i>1)
return true
else
return false
Insert formula global into the banded page header panel and assign it an initial value 0. Insert formula groupHD into the group header panel so that for each group i will be calculated as i+1. Then, select the group header panel and let formula FormulaControl control its On New Page property. This formula will only return true for the property if i>1.
The default value for Repeat is false. For one detail panel which spans a large space vertically to be shown in several pages, we support the Repeat property if you want to see the group header information in each page. When the Repeat property is set true and group headers are visible, the group headers will duplicate on every page. The Repeat property is a Boolean variable and can be changed by a formula.
Notes: