Previous Topic  Next Topic

Banded Page Header Properties

This topic describes the properties of a Banded Page Header object.

Designer provides some properties only when you use the object in certain report types. You can get details from the Available For column in the property table.

Property Name	Available For	Description
General
Class Type	Query Page Report	Shows the class type of the object. This property is read only.
Data Inherit	Query Page Report	Shows whether the object inherits dataset from another object. This property is read only.
Dataset	Query Page Report	Shows the dataset the object applies. This property is read only.
Instance Name	Query Page Report	Shows the instance name of the object. This property is read only.
Geometry
Height	Page Report, Web Report	Specifies the height of the object. Type a numeric value to change the height. Data type: Float
Width	Page Report, Web Report	Specifies the width of the object. Type a numeric value to change the width. Data type: Float
Color
Background	Page Report, Web Report	Specifies the background color or fill effect of the object. Choose a color from the drop-down list or select Custom to customize a color in the color palette, or type a hexadecimal RGB value (for example, 0xff0000) to specify a color. For a page report, you can also use a formula or edit an expression to return a color. Data type: String
CSS
Class	Page Report, Web Report	Specifies the name of the Class Selector to apply to the object, which you define in the CSS file of the style the report applies. For example, if you define the CSS file as follows: @charset "GBK"; TextField {Background: #ff0000} /*Style=LabelX*/ TextField[Style="LabelX"]{Background: #0000FF} /*ID=W*/ TextField#W{Background: #FFFF00} /*class=C*/ TextField.C{Background: #00FFFF} To apply the Class Selector in the file to the object, type C in the value cell. Data type: String
Style	Page Report, Web Report	Specifies the style you want to apply to the object. You can specify the style in two ways: Type the style which should be an Attribute Selector whose attribute is "style" in the CSS file of the style the report applies. For example, to apply the style in the above sample CSS file to the object, type LabelX in the value cell. Choose a style from the drop-down list if you have specified the Style Group property for the report tab or web report, and there are styles in the style group that are applicable to the object. Data type: String
Others
Export to CSV	Page Report, Web Report	Specifies whether to include the object in the CSV output of the report. Data type: Boolean
Export to Excel	Page Report, Web Report	Specifies whether to include the object in the Excel output of the report. Data type: Boolean
Export to HTML	Page Report, Web Report	Specifies whether to include the object in the HTML output of the report. Data type: Boolean
Export to PDF	Page Report, Web Report	Specifies whether to include the object in the PDF output of the report. Data type: Boolean
Export to PostScript	Page Report, Web Report	Specifies whether to include the object in the PostScript output of the report. Data type: Boolean
Export to Report Result	Page Report, Web Report	Specifies whether to include the object when you preview the report in Page Report Result for a page report or Web Report Result for a web report in Designer, and when users run the report at runtime. Data type: Boolean
Export to RTF	Page Report, Web Report	Specifies whether to include the object in the RTF output of the report. Data type: Boolean
Export to Text	Page Report, Web Report	Specifies whether to include the object in the Text output of the report. Data type: Boolean
Export to XML	Page Report, Web Report	Specifies whether to include the object in the XML output of the report. Data type: Boolean
Invisible	Page Report, Web Report	Specifies whether to hide the object in the design area and in the report result. Logi Report Engine performs all the calculations that involve the object regardless of whether the object is visible or not. Data type: Boolean
Label	Page Report, Web Report	Specifies the tool tip you want to display for the panel when you hover over the left edge of the panel in the design area. Type a string to change the label. Data type: String
Merge to Next Panel	Page Report, Web Report	Specifies whether to merge the panel into the next panel in the Excel output of the report. Data type: Boolean
Record Location	Page Report, Web Report	Specifies the calculation point for the properties of the object that are controlled by formulas. This property takes effect only when the object is in a banded object. Choose an option from the drop-down list. default - Select to calculate the values of the properties in the default location where the object is placed. page header - Select to calculate the values of the properties in the banded page header panel. page footer - Select to calculate the values of the properties in the banded page footer panel. For more information, see Example 2: Showing a Label on Every Page Except the Last. Data type: Enumeration
Remove Blank Row	Page Report, Web Report	Specifies whether to remove the blank rows in the panel in the Excel output of the report. Data type: Boolean
Repeat in Detail Panel	Page Report, Web Report	Specifies whether to duplicate the objects in the panel in the detail panel in the Excel output of the report. Data type: Boolean
Show Bottom Line	Query Page Report	Specifies whether to add a horizontal line at the bottom of the panel in the report result. Data type: Boolean
Suppress	Page Report, Web Report	Specifies whether to suppress the object in the design area and in the report result. If you suppress an object, Logi Report Engine skips all formulas and calculations that involve the object. Data type: Boolean When you set both the Invisible and Suppress properties of an object to "true", Suppress has the higher priority.
Suppress Blank Panel	Page Report, Web Report	Specifies whether to exclude the panel in the report result when it contains no data. Data type: Boolean
Suppress When No Records	Page Report, Web Report	Specifies whether to exclude the object in the report result when no record is returned to its parent data component. Data type: Boolean
Underlay	Page Report, Web Report	Specifies whether to layer the panel beneath the next panel in the banded object. This property is read only for the banded page header panel, meaning, the panel cannot be underlaid. Data type: Boolean
Border
Border Color	Page Report, Web Report	Specifies the color for the border of the object. Choose a color from the drop-down list or select Custom to customize a color in the Pick a Color dialog box, or type a hexadecimal RGB value (for example, 0xff0000) to specify a color. For a page report, you can also use a formula or edit an expression to return a color. Data type: String
Border Joint	Page Report, Web Report	Specifies the joint style for the border lines of the object. Choose an option from the drop-down list. miter - Select to join path segments by extending their outside edges until they meet. round - Select to join path segments by rounding off the corner at a radius of half the line width. Data type: Enumeration
Border Thickness	Page Report, Web Report	Specifies the width for the border of the object. Type a numeric value to change the thickness. Data type: Float
Bottom Line	Page Report, Web Report	Specifies the line style for the bottom border of the object. Choose an option from the drop-down list. Data type: Enumeration
Left Line	Page Report, Web Report	Specifies the line style for the left border of the object. Choose an option from the drop-down list. Data type: Enumeration
Radius	Page Report, Web Report	Specifies the radius for the joint of the border lines, which takes effect when Border Joint is "round". Type a numeric value to change the radius. Data type: Integer
Right Line	Page Report, Web Report	Specifies the line style for the right border of the object. Choose an option from the drop-down list. Data type: Enumeration
Top Line	Page Report, Web Report	Specifies the line style for the top border of the object. Choose an option from the drop-down list. Data type: Enumeration
Accessibility
External CSS Class Selector	Query Page Report	Specifies the name of the Class Selector for the object in the HTML output of the report. Data type: String
External ID	Query Page Report	This property is mapped to the HTML attribute id, as specified by w3.org. Data type: String
Language	Query Page Report	This property is mapped to the HTML attribute lang, as specified by w3.org. Data type: String

Back to top

Merge to Next Panel, Remove Blank Row, Repeat in Detail Panel

You can control panels of a banded object in the Excel output by settings the three properties:

• Merge to Next Panel controls whether to merge the current panel into the next panel. It applies to the banded header, banded page header, group header, and group footer panels.
• Remove Blank Row controls whether to remove the blank rows in the panel. It applies to the banded page header, group header, and detail panels.
• Repeat in Detail Panel controls whether to duplicate the objects in certain panel in the detail panel as well. It applies to the banded page header and group header panels.

The three properties take effect only when the Columned property of the page report tab containing the banded object or the web report is "true", and there is an operation order when those three properties work together: Merge to Next Panel > Repeat in Detail Panel > Remove Blank Row.

Suppose you have a banded object as follows:

Then you set the Columned property of the report tab to "true" and Merge to Next Panel of the first group header panel to "true", and export the report to Excel using Column Format. In the Excel output, you can see that Logi Report Engine merges the two group panels into one and places the fields in the two panel in one cell.

In order to improve the layout of the Excel output, you can specify the Column Index and Row Index properties of the objects as follows:

Object	Column Index	Row Index
A	3	1
B	4	1
C	1	1
D	2	1
E	3	1
F	4	1

Then, fields in the Excel output can display more clearly.

• Do not set Merge to Next Panel to "true" for the last group footer panel, because this can make the Excel output incorrect.
  
  
• Do not set Merge to Next Panel to "true" for the panel that contains a crosstab or subreport.
• If a banded object contains more than one groups, meaning, it has several group header panels, when you specify to repeat the first group header panel in the detail panel, Logi Report Engine also repeats it in the second group header panel in the Excel output.
• When two or more objects in the to-be-merged panels have the same Column Index and Row Index property values, after Logi Report Engine merges the panels, in the Excel output, it merges the objects into one cell and places them in the cell based on this rule: the object whose X/Y property value is smaller than others is put to front, and Y has higher priority than X.
• When the objects in the group header/banded page header panel have the same Row Index and Column Index property values with those in the detail panel, and you specify to repeat the group header/banded page header panel in the detail panel, in the Excel output, Logi Report Engine places the repeated objects in the same cells with the ones in the detail panel based on this rule: the object whose X/Y property value is smaller than others is put to front, and Y has higher priority than X.

Back to top

Previous Topic  Next Topic