Difference between revisions of "Report Options"
From Lianjapedia
Redirect page
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) (Redirected page to Lianja 5 Report Options) |
||
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | #REDIRECT [[Lianja 5 Report Options]] | |
==See Also== | ==See Also== | ||
− | [[Report Section Attributes]] | + | [[Developing Quick Reports]], [[Report Section Attributes]] |
==Overview== | ==Overview== | ||
Line 50: | Line 50: | ||
Note that the report is based on a single table. However, this table can be a Virtual Table based on a SQL Select query to local or remote tables. See [[:Category:Third Party Database Connectivity|here]] for information on Virtual Tables. | Note that the report is based on a single table. However, this table can be a Virtual Table based on a SQL Select query to local or remote tables. See [[:Category:Third Party Database Connectivity|here]] for information on Virtual Tables. | ||
− | The Report Section options are described here | + | |
+ | The Report Section options are described here: | ||
===Report type=== | ===Report type=== | ||
Line 79: | Line 80: | ||
===Fields=== | ===Fields=== | ||
The '''Fields''' attribute specifies the fields to be included in the report. This should be a comma separated list of field names or expressions. | The '''Fields''' attribute specifies the fields to be included in the report. This should be a comma separated list of field names or expressions. | ||
− | |||
− | |||
e.g. | e.g. | ||
<pre>account_no, upper(concat(title," ",first_name,last_name)),limit</pre> | <pre>account_no, upper(concat(title," ",first_name,last_name)),limit</pre> | ||
+ | |||
+ | or, to select all fields in the table as in the example_webapp2 reports: | ||
+ | |||
+ | <pre>*</pre> | ||
The '''Fields''' attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportFields]]. | The '''Fields''' attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportFields]]. | ||
Line 119: | Line 122: | ||
===Subtotals=== | ===Subtotals=== | ||
− | The '''Subtotals''' attribute specifies the columns in the report to be sub-totalled. This should be a comma separated list of numeric column positions. | + | The '''Subtotals''' attribute specifies the columns in the report to be sub-totalled. This should be a comma separated list of numeric column positions of numeric fields. |
+ | |||
+ | e.g. | ||
+ | |||
+ | <pre>9,10,11</pre> | ||
The '''Subtotals''' attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportSubTotals]]. | The '''Subtotals''' attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportSubTotals]]. | ||
Line 127: | Line 134: | ||
===Group by=== | ===Group by=== | ||
The '''Group by''' attribute specifies the name of the field or the expression that the report data will be grouped by for sub-totalling. | The '''Group by''' attribute specifies the name of the field or the expression that the report data will be grouped by for sub-totalling. | ||
+ | |||
+ | e.g. | ||
+ | |||
+ | <pre>state</pre> | ||
The '''Group by''' attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportGroupBy]]. | The '''Group by''' attribute can be queried or changed programmatically using [[Working with the Lianja Object Model|Lianja.getElementByID("page.section").reportGroupBy]]. | ||
Line 148: | Line 159: | ||
===Pagination=== | ===Pagination=== | ||
The '''Pagination''' attribute specifies whether the rows displayed should be paginated (True | False). | The '''Pagination''' attribute specifies whether the rows displayed should be paginated (True | False). | ||
+ | |||
+ | Pagination is not currently implemented. | ||
===Pagination size=== | ===Pagination size=== | ||
The '''Pagination size''' attribute specifies the number of rows to display per page. | The '''Pagination size''' attribute specifies the number of rows to display per page. | ||
+ | |||
+ | Pagination is not currently implemented. | ||
===Other options=== | ===Other options=== | ||
Line 170: | Line 185: | ||
[[#Notes on Client Support|Notes on Client Support]] | [[#Notes on Client Support|Notes on Client Support]] | ||
+ | |||
+ | ==Delegate Behavior== | ||
+ | |||
+ | ===Delegate hyperlinks=== | ||
+ | Delegate hyperlinks in page to page and/or section (True | False). | ||
+ | |||
+ | ===Delegate page=== | ||
+ | Delegate page name to search (leave blank if current page). | ||
+ | |||
+ | ===Delegate section=== | ||
+ | Delegate section name (leave blank if default searchkey section on page). | ||
+ | |||
+ | ===Delegate script=== | ||
+ | Delegate script name (URL is passed as character string). | ||
==Notes on Client Support== | ==Notes on Client Support== | ||
Line 195: | Line 224: | ||
|valign="top"|Hyperlinks||Lianja.getElementByID("page.section").reportHyperlink is exposed on the Desktop client only (Lianja/VFP). | |valign="top"|Hyperlinks||Lianja.getElementByID("page.section").reportHyperlink is exposed on the Desktop client only (Lianja/VFP). | ||
|- | |- | ||
− | |valign="top"|Show grid lines||Lianja.getElementByID("page.section").reportGridLines is exposed on the Desktop client only (Lianja/VFP). | + | |valign="top"|Show grid lines||Grid lines are currently always shown.<br>Lianja.getElementByID("page.section").reportGridLines is exposed on the Desktop client only (Lianja/VFP). |
|- | |- | ||
− | |valign="top"|Pagination|| | + | |valign="top"|Pagination||Pagination is not currently implemented. |
|- | |- | ||
− | |valign="top"|Pagination size|| | + | |valign="top"|Pagination size||Pagination is not currently implemented. |
|- | |- | ||
|valign="top"|Other options||Lianja.getElementByID("page.section").reportOtherOptions is exposed on the Desktop client only (Lianja/VFP). | |valign="top"|Other options||Lianja.getElementByID("page.section").reportOtherOptions is exposed on the Desktop client only (Lianja/VFP). | ||
+ | |- | ||
+ | |valign="top"|Delegate hyperlinks|| | ||
+ | |- | ||
+ | |valign="top"|Delegate page|| | ||
+ | |- | ||
+ | |valign="top"|Delegate section|| | ||
+ | |- | ||
+ | |valign="top"|Delegate script|| | ||
|- | |- | ||
|} | |} | ||
Line 231: | Line 268: | ||
==Reporting Alternatives== | ==Reporting Alternatives== | ||
The Lianja ODBC Driver, in conjunction with the Lianja SQL Server, can be used with third party report writers such as Crystal Reports or Microsoft Report Builder. | The Lianja ODBC Driver, in conjunction with the Lianja SQL Server, can be used with third party report writers such as Crystal Reports or Microsoft Report Builder. | ||
+ | |||
[[Category:Attribute Categories]] | [[Category:Attribute Categories]] | ||
+ | [[Category:Sections]] |