Report Options
Under Construction
Contents
See Also
Overview
Report options
Double-click the Section header or click the cog icon to access the Section Attributes.
The Details section at the top of the attributes dialog holds the specification of the database and table.
The Report Section options are described here.
Report type
Select from a known report type (Tabular)
Heading
The report heading
The Heading attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportHeading.
Filter
The filter expression that restricts which records will be included in the report
The Filter attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportFilter.
Fields
A comma separated list of field names or expressions (* selects all fields in the table)
The Fields attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportFields.
Columns
A comma separated list of column positions from the fields selected, e.g. 2,4,7,1.
The Columns attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportColumns.
Column headings
A comma separated list of report column headings
The Column headings attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportColumnHeadings or Lianja.getElementByID("page.section").reportHeadings.
Subtotals
A comma separated list of column positions from the fields selected to subtotal on
The Subtotals attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportSubTotals.
Group by
The field name or expression that data will be grouped by for sub totalling
The Group by attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportGroupBy.
Hyperlinks
A comma separated list of field names to render as hyperlinks for searching
The Hyperlinks attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportHyperlink.
Show grid lines
Show grid lines for each row of the report (True | False).
The Show grid lines attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportGridLines.
Pagination
Paginate the rows displayed (True | False).
Pagination size
The number of rows to paginate
Other options
Other report options
The Other options attribute can be queried or changed programmatically using Lianja.getElementByID("page.section").reportOtherOptions.
Notes on Client Support
| Attribute | Notes |
|---|---|
| Report type | - |
| Heading | Lianja.getElementByID("page.section").reportHeading is exposed on the Desktop client only (Lianja/VFP). |
| Filter | Lianja.getElementByID("page.section").reportFilter is exposed on the Desktop client only (Lianja/VFP). |
| Fields | Lianja.getElementByID("page.section").reportFields is exposed on the Desktop client only (Lianja/VFP). |
| Columns | Lianja.getElementByID("page.section").reportColumns is exposed on the Desktop client only (Lianja/VFP). |
| Column headings | Lianja.getElementByID("page.section").reportColumnHeadings and Lianja.getElementByID("page.section").reportHeadings are exposed on the Desktop client only (Lianja/VFP). |
| Subtotals | Lianja.getElementByID("page.section").reportSubTotals is exposed on the Desktop client only (Lianja/VFP). |
| Group by | Lianja.getElementByID("page.section").reportGroupBy is exposed on the Desktop client only (Lianja/VFP). |
| Hyperlinks | Lianja.getElementByID("page.section").reportHyperlink is exposed on the Desktop client only (Lianja/VFP). |
| Show grid lines | Lianja.getElementByID("page.section").reportGridLines is exposed on the Desktop client only (Lianja/VFP). |
| Pagination | - |
| Pagination size | - |
| Other options | Lianja.getElementByID("page.section").reportOtherOptions is exposed on the Desktop client only (Lianja/VFP). |
