Difference between revisions of "Reports Workspace"

Revision as of 10:37, 14 August 2019

Under Construction. Coming soon in Lianja v5.0

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 below.

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
Group By List
Sort By
Sort By List

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

Footer

Setting	Default	Description
Footer Height
Footer Image
Custom Footer

@@ Line 10: / Line 10: @@
 ==Reports==
-Select an existing report from the pulldown.
+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.
+[[{{ns:file}}:l5_report_options1.png|800px|border|left|link={{filepath:l5_report_options1.png}}|Report Builder]]
+<br clear=all>
 ==Data Source==
 {| class="wikitable" width="100%"
-!width="20%"|Item
+!width="15%"|Setting
-!width="80%"|Description
+!width="25%"|Required
+!width="65%"|Description
 |-
 |valign="top"|Connection
-|valign="top"|
+|valign="top"|No
+|valign="top"|The ODBC DSN for the data source.  The pulldown lists available 32-bit ODBC DSNs.
 |-
 |valign="top"|Database
-|valign="top"|
+|valign="top"|Yes, unless '''Custom SQL''' is specified and references the database name, e.g. ''select * from southwind&#33;shippers''.||valign="top"|The database for the data source.  The pulldown lists available Lianja databases.
 |-
 |valign="top"|Table
-|valign="top"|
+|valign="top"|Yes, unless '''Custom SQL''' is specified
+|valign="top"|The table for the data source.  The pulldown lists tables from the specified '''Database'''.
 |-
 |valign="top"|Fields
-|valign="top"|
+|valign="top"|Yes, unless '''Custom SQL''' is specified
+|valign="top"|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'''.
 |-
 |valign="top"|Filter
-|valign="top"|
+|valign="top"|No
+|valign="top"|The filter condition to be applied to the records from the '''Table'''.  Click the [...] button to display the 'Custom Query Builder'.
 |-
 |valign="top"|Custom SQL
-|valign="top"|
+|valign="top"|No, unless '''Table''' is not specified
+|valign="top"|The [[SQL SELECT|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 below.
 ==Page Layout==
 {| class="wikitable" width="100%"
-!width="20%"|Item
+!width="15%"|Setting
-!width="80%"|Description
+!width="25%"|Default
+!width="65%"|Description
 |-
 |valign="top"|Paper Size
-|valign="top"|
+|valign="top"|Letter
+|valign="top"|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'''.
 |-
 |valign="top"|Custom Paper Size
 |valign="top"|
+|valign="top"|The paper dimensions if ''Custom'' is selected as the '''Paper Size'''.
 |-
 |valign="top"|Rows per page
 |valign="top"|
+|valign="top"|The number of rows to display per page when printing the report.
 |-
 |valign="top"|Row Height
-|valign="top"|
+|valign="top"|0 (autosize)
+|valign="top"|The row height in pixels when printing the report.
 |-
 |valign="top"|Show Grid Lines
-|valign="top"|
+|valign="top"|True
+|valign="top"|Whether grid lines should be shown when printing the report.
 |-
 |valign="top"|Show Page Numbers
-|valign="top"|
+|valign="top"|True
+|valign="top"|Whether page numbers (nPage of nPages) should be shown in the page footer when printing the report.
 |-
 |valign="top"|Page Top Margin
-|valign="top"|
+|valign="top"|50
+|valign="top"|The height in pixels of the page top margin when printing the report.
 |-
 |valign="top"|Page Bottom Margin
-|valign="top"|
+|valign="top"|0
+|valign="top"|The height in pixels of the page bottom margin when printing the report.
 |-
 |valign="top"|Show Date/Time
-|valign="top"|
+|valign="top"|True
+|valign="top"|Whether the date and time should be shown in the page footer when printing the report.
 |-
 |}
@@ Line 73: / Line 93: @@
 ==Grouping==
 {| class="wikitable" width="100%"
-!width="20%"|Item
+!width="15%"|Setting
-!width="80%"|Description
+!width="25%"|Default
+!width="65%"|Description
 |-
 |valign="top"|Group By
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Group By List
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Sort By
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Sort By List
+|valign="top"|
 |valign="top"|
 |-
@@ Line 92: / Line 117: @@
 ==Header==
 {| class="wikitable" width="100%"
-!width="20%"|Item
+!width="15%"|Setting
-!width="80%"|Description
+!width="25%"|Default
+!width="65%"|Description
 |-
 |valign="top"|Main Heading
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Sub-Heading
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Header Height
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Header Image
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Custom Header
+|valign="top"|
 |valign="top"|
 |-
@@ Line 114: / Line 145: @@
 ==Detail==
 {| class="wikitable" width="100%"
-!width="20%"|Item
+!width="15%"|Setting
-!width="80%"|Description
+!width="25%"|Default
+!width="65%"|Description
 |-
 |valign="top"|Column
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Column Expression
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Heading
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Alignment
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Display Mask
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Data Mapping
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Dynamic BackColor
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Dynamic ForeColor
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Hyperlink
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Sub-total
+|valign="top"|
 |valign="top"|
 |-
@@ Line 151: / Line 193: @@
 ==Footer==
 {| class="wikitable" width="100%"
-!width="20%"|Item
+!width="15%"|Setting
-!width="80%"|Description
+!width="25%"|Default
+!width="65%"|Description
 |-
 |valign="top"|Footer Height
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Footer Image
+|valign="top"|
 |valign="top"|
 |-
 |valign="top"|Custom Footer
+|valign="top"|
 |valign="top"|
 |-
 |}
 [[Category:Workspaces]]
 [[Category:Lianja v5.0]]