Difference between revisions of "Reports Workspace"

From Lianjapedia
Jump to: navigation, search
(Header)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
''Under Construction.  Coming soon in Lianja v5.0''
+
''Coming soon in Lianja v5.0''
  
 
==Overview==
 
==Overview==
Line 155: Line 155:
 
|valign="top"|Header Image
 
|valign="top"|Header Image
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The name of an image file to be displayed as the background to the header for the printed report.
 
|-
 
|-
 
|valign="top"|Custom Header
 
|valign="top"|Custom Header
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The name of a Lianja/VFP program or procedure to output HTML for the display of a custom header for the printed report.
 
|-
 
|-
 
|}
 
|}
Line 177: Line 177:
 
|valign="top"|Column Expression
 
|valign="top"|Column Expression
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The expression to be displayed in the column.
 
|-
 
|-
 
|valign="top"|Heading
 
|valign="top"|Heading
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The heading for the column.
 
|-
 
|-
 
|valign="top"|Alignment
 
|valign="top"|Alignment
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The alignment for the column (Left | Center | Right).
 
|-
 
|-
 
|valign="top"|Display Mask
 
|valign="top"|Display Mask
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The display [[Input Masks|mask]] for the column.
 
|-
 
|-
 
|valign="top"|Data Mapping
 
|valign="top"|Data Mapping
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The [[Data Mapping|data mapping]] for the column.
 
|-
 
|-
 
|valign="top"|Dynamic BackColor
 
|valign="top"|Dynamic BackColor
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|MIME base64 encoded string containing a color value.
 
|-
 
|-
 
|valign="top"|Dynamic ForeColor
 
|valign="top"|Dynamic ForeColor
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|MIME base64 encoded string containing a color value.
 
|-
 
|-
 
|valign="top"|Hyperlink
 
|valign="top"|Hyperlink
 
|valign="top"|False
 
|valign="top"|False
|valign="top"|
+
|valign="top"|Whether the column contents should be displayed as a hyperlink.
 
|-
 
|-
 
|valign="top"|Sub-total
 
|valign="top"|Sub-total
 
|valign="top"|False
 
|valign="top"|False
|valign="top"|
+
|valign="top"|Whether the column should be sub-totalled.
 
|-
 
|-
 
|}
 
|}
Line 227: Line 227:
 
|valign="top"|Footer Image
 
|valign="top"|Footer Image
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The name of an image file to be displayed as the background to the footer for the printed report.
 
|-
 
|-
 
|valign="top"|Custom Footer
 
|valign="top"|Custom Footer
 
|valign="top"|
 
|valign="top"|
|valign="top"|
+
|valign="top"|The name of a Lianja/VFP program or procedure to output HTML for the display of a custom footer for the printed report.
 
|-
 
|-
 
|}
 
|}

Latest revision as of 06:19, 11 October 2019

Coming soon in Lianja v5.0

Overview

Reports Workspace


Buttons

Reports Workspace


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.

Report Builder


Data Source

The Data Source settings allow the ODBC or native Lianja data source to be configured.

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

The Page Layout settings determine the layout when the report is printed.

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 3 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

The Grouping settings determine the optional grouping and sort order columns for the report. These include options to allow the end user to select from a specified list of columns.

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.

Here the employees report has been altered to specify the Group By List as:

reportsto|lastname

and the Sort By List as:

lastname|firstname

The user can select from the lists to change the grouping and sort order columns active in the report.

Report Builder Grouping


Header

The Header settings allow the main and sub headings to be configured.

Setting Default Description
Main Heading {reportname} report for user {username} The main heading shown when the report is printed. For the default main heading, the {} macros are expanded to display the reportname and current username.
Sub-Heading A sub-header shown in both the on-screen and printed report.
Header Height The height of the Main Heading in pixels for the printed report.
Header Image The name of an image file to be displayed as the background to the header for the printed report.
Custom Header The name of a Lianja/VFP program or procedure to output HTML for the display of a custom header for the printed report.

Detail

The Detail settings allow the display of individual columns to be configured.

Setting Default Description
Column Select the column to be configured from the pulldown.
Column Expression The expression to be displayed in the column.
Heading The heading for the column.
Alignment The alignment for the column (Left | Center | Right).
Display Mask The display mask for the column.
Data Mapping The data mapping for the column.
Dynamic BackColor MIME base64 encoded string containing a color value.
Dynamic ForeColor MIME base64 encoded string containing a color value.
Hyperlink False Whether the column contents should be displayed as a hyperlink.
Sub-total False Whether the column should be sub-totalled.

Footer

The Footer settings determine the display of the page footer when the report is printed.

Setting Default Description
Footer Height 25 The page footer height in pixels.
Footer Image The name of an image file to be displayed as the background to the footer for the printed report.
Custom Footer The name of a Lianja/VFP program or procedure to output HTML for the display of a custom footer for the printed report.