Difference between revisions of "Reports Workspace"
From Lianjapedia
Yvonne.milne (Talk | contribs) (→Data Source) |
Yvonne.milne (Talk | contribs) (→Grouping) |
||
| Line 99: | Line 99: | ||
|valign="top"|Group By | |valign="top"|Group By | ||
|valign="top"| | |valign="top"| | ||
| − | |valign="top"| | + | |valign="top"|The grouping column for the records in the report. A ''Sub-totals:'' footer will be displayed for each group. Individual columns can be flagged to be sub-totalled in the '''Detail''' report configuration tab. |
|- | |- | ||
|valign="top"|Group By List | |valign="top"|Group By List | ||
|valign="top"| | |valign="top"| | ||
| − | |valign="top"| | + | |valign="top"|A '''|''' separated list of columns that the user can select from to set the grouping for the records in the report. |
|- | |- | ||
|valign="top"|Sort By | |valign="top"|Sort By | ||
|valign="top"| | |valign="top"| | ||
| − | |valign="top"| | + | |valign="top"|The sort order column for the records in the report. |
|- | |- | ||
|valign="top"|Sort By List | |valign="top"|Sort By List | ||
|valign="top"| | |valign="top"| | ||
| − | |valign="top"| | + | |valign="top"|A '''|''' separated list of columns that the user can select from to set the sort order for the records in the report. |
|- | |- | ||
|} | |} | ||
Revision as of 12:07, 14 August 2019
Under Construction. Coming soon in Lianja v5.0
Contents
Overview
Buttons
Reports
Select an existing report from the pulldown. Reports built in the Report Builder are saved to the Library reports directory so they can be used in multiple Apps. The Lianja App Builder distribution comes with some pre-built demo reports.
Data Source
| Setting | Required | Description |
|---|---|---|
| Connection | No | The ODBC DSN for the data source. The pulldown lists available 32-bit ODBC DSNs. |
| Database | Yes, unless Custom SQL is specified and references the database name, e.g. select * from southwind!shippers. | The database for the data source. The pulldown lists available Lianja databases. |
| Table | Yes, unless Custom SQL is specified | The table for the data source. The pulldown lists tables from the specified Database. |
| Fields | Yes, unless Custom SQL is specified | The fields to be included from the Table. Click the [...] button to display the 'Choose fields' dialog. The default is * indicating all fields from the Table. |
| Filter | No | The filter condition to be applied to the records from the Table. Click the [...] button to display the 'Custom Query Builder'. |
| Custom SQL | No, unless Table is not specified | The SQL select query for the data source. |
Once the Database and Table or Custom SQL have been specified, additional report configuration tabs are shown and the live report is displayed.
Page Layout
| Setting | Default | Description |
|---|---|---|
| Paper Size | Letter | Select the paper size to be used when printing the report. If Custom is selected, the dimensions can be specified in the Custom Paper Size. |
| Custom Paper Size | The paper dimensions if Custom is selected as the Paper Size. | |
| Rows per page | The number of rows to display per page when printing the report. | |
| Row Height | 0 (autosize) | The row height in pixels when printing the report. |
| Show Grid Lines | True | Whether grid lines should be shown when printing the report. |
| Show Page Numbers | True | Whether page numbers (nPage of nPages) should be shown in the page footer when printing the report. |
| Page Top Margin | 50 | The height in pixels of the page top margin when printing the report. |
| Page Bottom Margin | 0 | The height in pixels of the page bottom margin when printing the report. |
| Show Date/Time | True | Whether the date and time should be shown in the page footer when printing the report. |
Grouping
| Setting | Default | Description |
|---|---|---|
| Group By | The grouping column for the records in the report. A Sub-totals: footer will be displayed for each group. Individual columns can be flagged to be sub-totalled in the Detail report configuration tab. | |
| Group By List | A | separated list of columns that the user can select from to set the grouping for the records in the report. | |
| Sort By | The sort order column for the records in the report. | |
| Sort By List | A | separated list of columns that the user can select from to set the sort order for the records in the report. |
Header
| Setting | Default | Description |
|---|---|---|
| Main Heading | ||
| Sub-Heading | ||
| Header Height | ||
| Header Image | ||
| Custom Header |
Detail
| Setting | Default | Description |
|---|---|---|
| Column | ||
| Column Expression | ||
| Heading | ||
| Alignment | ||
| Display Mask | ||
| Data Mapping | ||
| Dynamic BackColor | ||
| Dynamic ForeColor | ||
| Hyperlink | ||
| Sub-total |
| Setting | Default | Description |
|---|---|---|
| Footer Height | ||
| Footer Image | ||
| Custom Footer |
