Difference between revisions of "Report Options"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 26: | Line 26: | ||
===Heading=== | ===Heading=== | ||
The report heading | The report heading | ||
| + | |||
| + | The Heading attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportHeading]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Filter=== | ===Filter=== | ||
The filter expression that restricts which records will be included in the report | The filter expression that restricts which records will be included in the report | ||
| + | |||
| + | The Filter attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportFilter]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Fields=== | ===Fields=== | ||
A comma separated list of field names or expressions (* selects all fields in the table) | 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 [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportFields]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Columns=== | ===Columns=== | ||
| − | A comma separated list of column positions from the fields selected, e.g. 2,4,7,1 | + | 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 [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportColumns]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Column headings=== | ===Column headings=== | ||
A comma separated list of report column headings | A comma separated list of report column headings | ||
| + | |||
| + | The Column headings attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportColumnHeadings]] or [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportHeadings]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Subtotals=== | ===Subtotals=== | ||
A comma separated list of column positions from the fields selected to subtotal on | A comma separated list of column positions from the fields selected to subtotal on | ||
| + | The Subtotals attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportSubTotals]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Group by=== | ===Group by=== | ||
The field name or expression that data will be grouped by for sub totalling | 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 [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportGroupBy]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Hyperlinks=== | ===Hyperlinks=== | ||
A comma separated list of field names to render as hyperlinks for searching | A comma separated list of field names to render as hyperlinks for searching | ||
| + | |||
| + | The Hyperlinks attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportHyperlink]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Show grid lines=== | ===Show grid lines=== | ||
Show grid lines for each row of the report (True | False). | Show grid lines for each row of the report (True | False). | ||
| + | |||
| + | The Show grid lines attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportGridLines]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
===Pagination=== | ===Pagination=== | ||
| Line 59: | Line 93: | ||
===Other options=== | ===Other options=== | ||
Other report options | Other report options | ||
| + | |||
| + | The Other options attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportOtherOptions]]. | ||
| + | |||
| + | [[#Notes on Client Support|Notes on Client Support]] | ||
==Notes on Client Support== | ==Notes on Client Support== | ||
| Line 68: | Line 106: | ||
|valign="top"|Report type||- | |valign="top"|Report type||- | ||
|- | |- | ||
| − | |valign="top"|Heading|| | + | |valign="top"|Heading||Lianja.getElementByID("page.section").reportHeading is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
| − | |valign="top"|Filter|| | + | |valign="top"|Filter||Lianja.getElementByID("page.section").reportFilter is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
| − | |valign="top"|Fields|| | + | |valign="top"|Fields||Lianja.getElementByID("page.section").reportFields is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
| − | |valign="top"|Columns|| | + | |valign="top"|Columns||Lianja.getElementByID("page.section").reportColumns is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
| − | |valign="top"|Column headings|| | + | |valign="top"|Column headings||Lianja.getElementByID("page.section").reportColumnHeadings is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
| − | |valign="top"|Subtotals|| | + | |valign="top"|Subtotals||Lianja.getElementByID("page.section").reportSubTotals is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
| − | |valign="top"|Group by|| | + | |valign="top"|Group by||Lianja.getElementByID("page.section").reportGroupBy is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
| − | |valign="top"|Hyperlinks|| | + | |valign="top"|Hyperlinks||Lianja.getElementByID("page.section").reportHyperlink is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
| − | |valign="top"|Show grid lines|| | + | |valign="top"|Show grid lines||Lianja.getElementByID("page.section").reportGridLines is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
|valign="top"|Pagination||- | |valign="top"|Pagination||- | ||
| Line 90: | Line 128: | ||
|valign="top"|Pagination size||- | |valign="top"|Pagination size||- | ||
|- | |- | ||
| − | |valign="top"|Other options|| | + | |valign="top"|Other options||Lianja.getElementByID("page.section").reportOtherOptions is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
|} | |} | ||
[[Category:Attribute Categories]] | [[Category:Attribute Categories]] | ||
Revision as of 07:45, 20 January 2016
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 is 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). |
