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) |
||
| (8 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 80: | 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 120: | 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 128: | 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 149: | 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 171: | 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 196: | 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 232: | 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]] | ||
