Difference between revisions of "Section Summary"

From Lianjapedia
Jump to: navigation, search
(→‎Notes on Client Support)
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
==Overview==
 
Grid and Attachments Sections can have a Summary displayed at the bottom of the section to show column totals.
 
Grid and Attachments Sections can have a Summary displayed at the bottom of the section to show column totals.
  
−
Double-click on the Section header or click the cog icon to access the Section Attributes. Scroll down to the Search Panel sub-section.
+
From v6.0, the Summary can also include Minimum, Maximum and Average column values.
−
 
+
[[{{ns:file}}:l6_summary_minmaxavgtot.png|800px|left|border|link={{filepath:l6_summary_minmaxavgtot.png}}|Section Summary: Minimum, Maximum, Average, Total]]
 +
<br clear=all>
  
 
==Visible==
 
==Visible==
−
[[{{ns:file}}:summary_visible_false.png|450px|thumb|left|link={{filepath:summary_visible_false.png}}|Section Summary: default Visible is False]]
 
−
 
−
 
−
 
 
By default, the Section Summary is not visible.
 
By default, the Section Summary is not visible.
 +
[[{{ns:file}}:l6_summary_visible_false.png|800px|left|border|link={{filepath:l6_summary_visible_false.png}}|Section Summary: default Visible is False]]
 +
<br clear=all>
  
 +
To make the Section Summary visible, check the '''Visible''' attribute to True.  The '''Total''' attribute is checked by default.
 +
[[{{ns:file}}:l6_summary_visible_true.png|800px|left|border|link={{filepath:l6_summary_visible_true.png}}|Section Summary: set Visible to True]]
 
<br clear=all>
 
<br clear=all>
  
−
[[{{ns:file}}:summary_visible_true.png|450px|thumb|left|link={{filepath:summary_visible_true.png}}|Section Summary: set Visible to True]]
+
Information will only be displayed in the Section Summary when one or more Columns in the Grid or Attachments Section have their '''Summary column''' attribute set to True.
 +
[[{{ns:file}}:l6_summary_total_column.png|800px|left|border|link={{filepath:l6_summary_total_column.png}}|Section Summary: Summary column]]
 +
<br clear=all>
  
 +
Notes:
 +
* The '''Summary column''' attribute was named '''Total this column''' prior to v6.0.
 +
* The '''Total expression''' attribute allows an alternative expression to be specified for the column Total displayed in the Summary.
 +
* The '''Summary format''' attribute allows formatting options to be specified for all Summary values: Minimum, Maximum, Average, Total.  Prior to v6.0 it was named '''Total format'''.
  
 +
[[#Notes on Client Support|Notes on Client Support]]
  
−
To make the Section Summary visible, check the Visible attribute to True.
+
==Minimum==
 +
Check the '''Minimum''' attribute to true to display the minimum value in the Summary.  From v6.0.
  
−
<br clear=all>
+
See screenshot [[#Overview|above]].
  
−
[[{{ns:file}}:summary_total_column.png|450px|thumb|left|link={{filepath:summary_total_column.png}}|Section Summary: Total this column]]
+
[[#Notes on Client Support|Notes on Client Support]]
  
 +
==Maximum==
 +
Check the '''Maximum''' attribute to true to display the maximum value in the Summary.  From v6.0.
  
 +
See screenshot [[#Overview|above]].
  
−
Information will only be displayed in the Section Summary when one or more Columns in the Grid or Attachments Section have their '''Total this column''' attribute set to True.
+
[[#Notes on Client Support|Notes on Client Support]]
  
−
To access the Attributes for a Column, double-click on its header.
+
==Average==
 +
Check the '''Average''' attribute to true to display the average value in the Summary.  From v6.0.
  
−
<br clear=all>
+
See screenshot [[#Overview|above]].
  
 
[[#Notes on Client Support|Notes on Client Support]]
 
[[#Notes on Client Support|Notes on Client Support]]
  
−
==Background color==
+
==Total==
 +
Check the '''Total''' attribute to true to display the column total in the Summary.
  
−
[[{{ns:file}}:summary_background_color.png|450px|thumb|left|link={{filepath:summary_background_color.png}}|Section Summary Background Color]]
+
See screenshot [[#Overview|above]].
  
 +
[[#Notes on Client Support|Notes on Client Support]]
  
 +
==Caption==
 +
A comma separated list of captions.  Defaults to Min,Max,Average,Total.  From v6.0.
  
−
The Background color is used to specify the Summary background color.
+
[[#Notes on Client Support|Notes on Client Support]]
  
−
Click the [...] button to access the 'Select Color' dialog.
+
==Background color==
 +
The '''Background color''' is used to specify the Summary background color.
  
 +
Click the [...] button to access the 'Select Color' dialog.
 +
[[{{ns:file}}:l6_summary_background_color.png|800px|left|border|link={{filepath:l6_summary_background_color.png}}|Section Summary Background Color]]
 
<br clear=all>
 
<br clear=all>
  
Line 48: Line 69:
  
 
==Foreground color==
 
==Foreground color==
 +
The '''Foreground color''' is used to specify the Summary foreground color (lines).
  
−
[[{{ns:file}}:summary_foreground_color.png|450px|thumb|left|link={{filepath:summary_foreground_color.png}}|Section Summary Foreground Color]]
+
Click the [...] button to access the 'Select Color' dialog.
 +
[[{{ns:file}}:l6_summary_foreground_color.png|800px|left|border|link={{filepath:l6_summary_foreground_color.png}}|Section Summary Foreground Color]]
 +
<br clear=all>
  
 +
[[#Notes on Client Support|Notes on Client Support]]
  
−
 
+
==Text color==
−
The Foreground color is used to specify the Summary foreground color.
+
The '''Text color''' is used to specify the Summary text color.  From v6.0.
  
 
Click the [...] button to access the 'Select Color' dialog.
 
Click the [...] button to access the 'Select Color' dialog.
−
 
+
[[{{ns:file}}:l6_summary_text_color.png|800px|left|border|link={{filepath:l6_summary_text_color.png}}|Section Summary Text Color]]
 
<br clear=all>
 
<br clear=all>
  
Line 62: Line 87:
  
 
==Attachments Sections==
 
==Attachments Sections==
−
 
−
[[{{ns:file}}:summary_attachments_section.png|450px|thumb|left|link={{filepath:summary_attachments_section.png}}|Attachments Sections Summary ]]
 
−
 
−
 
−
 
 
Attachments Sections can also have a Summary.
 
Attachments Sections can also have a Summary.
−
 
+
[[{{ns:file}}:l6_summary_attachments_section.png|800px|left|border|link={{filepath:l6_summary_attachments_section.png}}|Attachments Sections Summary ]]
 
<br clear=all>
 
<br clear=all>
  
Line 74: Line 94:
  
 
==Notes on Client Support==
 
==Notes on Client Support==
 +
[[{{ns:file}}:l6_summary_browser.png|800px|left|border|link={{filepath:l6_summary_browser.png}}|Section Summary: Browser]]
 +
<br clear=all>
  
 
{| class="wikitable" width="100%"
 
{| class="wikitable" width="100%"
Line 79: Line 101:
 
!width="80%"|Notes
 
!width="80%"|Notes
 
|-
 
|-
−
|valign="top"|Visible||The Section Summary is supported on the Desktop client only.
+
|valign="top"|Visible||The Section Summary is supported on all clients from v5.3.  Previously it was supported on the Desktop client only.
 +
|-
 +
|valign="top"|Minimum||-
 +
|-
 +
|valign="top"|Maximum||-
 +
|-
 +
|valign="top"|Average||-
 +
|-
 +
|valign="top"|Total||-
 +
|-
 +
|valign="top"|Caption||-
 +
|-
 +
|valign="top"|Background color||The Background color is supported on all clients from v6.0.  Previously it was supported on the Desktop client only.
 
|-
 
|-
−
|valign="top"|Background color||The Background color is supported on the Desktop client only.
+
|valign="top"|Foreground color||The Foreground color is supported on all clients from v6.0.  Previously it was supported on the Desktop client only.
 
|-
 
|-
−
|valign="top"|Foreground color||The Foreground color is supported on the Desktop client only.
+
|valign="top"|Text color||-
 
|-
 
|-
 
|}
 
|}
Line 89: Line 123:
 
[[Category:Attribute Categories]]
 
[[Category:Attribute Categories]]
 
[[Category:Sections]]
 
[[Category:Sections]]
 +
[[Category:SectionAnatomy]]
 +
[[Category:Lianja v6.0]]

Revision as of 11:30, 22 February 2021

Overview

Grid and Attachments Sections can have a Summary displayed at the bottom of the section to show column totals.

From v6.0, the Summary can also include Minimum, Maximum and Average column values.

Section Summary: Minimum, Maximum, Average, Total


Visible

By default, the Section Summary is not visible.

Section Summary: default Visible is False


To make the Section Summary visible, check the Visible attribute to True. The Total attribute is checked by default.

Section Summary: set Visible to True


Information will only be displayed in the Section Summary when one or more Columns in the Grid or Attachments Section have their Summary column attribute set to True.

Section Summary: Summary column


Notes:

  • The Summary column attribute was named Total this column prior to v6.0.
  • The Total expression attribute allows an alternative expression to be specified for the column Total displayed in the Summary.
  • The Summary format attribute allows formatting options to be specified for all Summary values: Minimum, Maximum, Average, Total. Prior to v6.0 it was named Total format.

Notes on Client Support

Minimum

Check the Minimum attribute to true to display the minimum value in the Summary. From v6.0.

See screenshot above.

Notes on Client Support

Maximum

Check the Maximum attribute to true to display the maximum value in the Summary. From v6.0.

See screenshot above.

Notes on Client Support

Average

Check the Average attribute to true to display the average value in the Summary. From v6.0.

See screenshot above.

Notes on Client Support

Total

Check the Total attribute to true to display the column total in the Summary.

See screenshot above.

Notes on Client Support

Caption

A comma separated list of captions. Defaults to Min,Max,Average,Total. From v6.0.

Notes on Client Support

Background color

The Background color is used to specify the Summary background color.

Click the [...] button to access the 'Select Color' dialog.

Section Summary Background Color


Notes on Client Support

Foreground color

The Foreground color is used to specify the Summary foreground color (lines).

Click the [...] button to access the 'Select Color' dialog.

Section Summary Foreground Color


Notes on Client Support

Text color

The Text color is used to specify the Summary text color. From v6.0.

Click the [...] button to access the 'Select Color' dialog.

Section Summary Text Color


Notes on Client Support

Attachments Sections

Attachments Sections can also have a Summary.

Attachments Sections Summary


Notes on Client Support

Notes on Client Support

Section Summary: Browser


Attribute Notes
Visible The Section Summary is supported on all clients from v5.3. Previously it was supported on the Desktop client only.
Minimum -
Maximum -
Average -
Total -
Caption -
Background color The Background color is supported on all clients from v6.0. Previously it was supported on the Desktop client only.
Foreground color The Foreground color is supported on all clients from v6.0. Previously it was supported on the Desktop client only.
Text color -
Retrieved from "https://www.lianja.com/doc/index.php?title=Section_Summary&oldid=24355"