Previous Topic
Line
The properties of a line object are as follows. A line object can be inserted into a banded object only.
| Property Name | Description |
|---|---|
| General | |
| 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 | |
| Bottom Attach Pos X | Specifies the horizontal coordinate of the bottom (or right when the line is horizontal) end point of the line in a banded panel. A drawing object can cross panels and the coordinate indicates the relative position in the involved panel. If the top and bottom end points are exchanged, this property works on the bottom end point after the exchange.
Data type: Float |
| Bottom Attach Pos Y | Specifies the vertical coordinate of the bottom (or right when the line is horizontal) end point of the line in a banded panel. A drawing object can cross panels and the coordinate indicates the relative position in the involved panel.
If the top and bottom end points are exchanged, this property works on the bottom end point after the exchange.
Data type: Float |
| Top Attach Pos X | Specifies the horizontal coordinate of the top (or left when the line is horizontal) end point of the line in a banded panel. A drawing object can cross panels and the coordinate indicates the relative position in the involved panel.
If the top and bottom end points are exchanged, this property works on the top end point after the exchange.
Data type: Float |
| Top Attach Pos Y | Specifies the vertical coordinate of the top (or left when the line is horizontal) end point of the line in a banded panel. A drawing object can cross panels and the coordinate indicates the relative position in the involved panel.
If the top and bottom end points are exchanged, this property works on the top end point after the exchange.
Data type: Float |
| Others | |
| Export to CSV | Specifies whether to include the object when exporting the report to CSV.
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 XML | Specifies whether to include the object in the XML result of the report.
Data type: Boolean |
| Invisible | Specifies whether to show the object in the report. All formulas and calculations will still be performed.
Data type: Boolean |
| Record Location | Specifies the calculation point for the properties of the object which are controlled by formulas. Choose an option from the drop-down list.
Data type: Enumeration |
| Suppress When No Records | Specifies whether to display the object in the report result when no record is returned to its parent data component.
Data type: Boolean |
| Excel | |
| Bottom Attach Column | Specifies the X coordinate of the lower right corner of the object in the exported Excel file, measured in cells.
Data type: Float |
| Bottom Attach Row | Specifies the Y coordinate of the lower right corner of the object in the exported Excel file, measured in cells.
Data type: Float |
| Top Attach Column | Specifies the X coordinate of the upper left corner of the object in the exported Excel file, measured in cells.
Data type: Float |
| Top Attach Row | Specifies the Y coordinate of the upper left corner of the object in the exported Excel file, measured in cells.
Data type: Float |
| Line Property | |
| Enable Bottom Arrow | Specifies whether to use an arrow as the bottom (or right when the line is horizontal) end of the line. If the top and bottom ends are exchanged, this property works on the bottom end after the exchange.
Data type: Boolean |
| Enable Top Arrow | Specifies whether to use an arrow as the top (or left when the line is horizontal) end of the line. If the top and bottom ends are exchanged, this property works on the top end after the exchange.
Data type: Boolean |
| Line Color | Specifies the color of the line. 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 |
| Line Style | Specifies the style of the line. Choose an option from the drop-down list.
Data type: Enumeration |
| Line Thickness | Specifies the thickness of the line. Enter a numeric value to change the thickness.
Data type: Float |
Bottom Attach Column, Bottom Attach Row, Top Attach Column, Top Attach Row
The four properties work together to control the position of a line in the exported Excel file. They take effect when the Columned property of the web report is set to true.
The first pair of the properties (Top Attach Column, Top Attach Row) locates a cell and uses its upper left corner as the upper left corner of the line, while the second pair (Bottom Attach Column, Bottom Attach Row) locates another cell and uses its upper left corner as the lower right corner of the line.
For example, if the properties for an oval are set as:
Top Attach Column: 1, Top Attach Row: 2, Bottom Attach Column: 3, Bottom Attach Row: 4
Then, the upper left cell will be A2 and the lower right cell will be C4.
Note: The value you set for the Top Attach Column (Top Attach Row) property should be always larger than that for the Bottom Attach Column (Bottom Attach Row) property.