Differences

This shows you the differences between two versions of the page.

--- gt3:loads:search:grid [03/06/2021 02:02]
Ian Davidson [Working With the Results Grid]
+++ gt3:loads:search:grid [03/06/2021 02:36] (current)
Ian Davidson [Adding Subtotals For Numeric Columns]
@@ Line 11: / Line 11: @@
 {{ :gt3:loads:search:search-21.png?nolink |}}
-You can also sort by multiple columns at once by holding down the **Shift** or **Ctrl** key and left-clicking another column heading (or right-clicking it and selecting an option from the popup menu). WHen you sort by multiple columns you get arrows in both columns, together with a number indicating which column is sorted first and so on:
+You can also sort by multiple columns at once by holding down the **Shift** or **Ctrl** key and left-clicking another column heading (or right-clicking it and selecting an option from the popup menu). When you sort by multiple columns you get arrows in both columns, together with a number indicating which column is sorted first and so on:
 {{ :gt3:loads:search:search-22.png?nolink |}}
@@ Line 23: / Line 23: @@
 {{ :gt3:loads:search:search-16.png?nolink |}}
-We scroll right to display the //Customer Name// column, right-click the column heading and select **Group By This Column** from the popup menu:
+We scroll horizontally if necessary to display the //Customer Name// column, right-click the column heading and select **Group By This Column** from the popup menu:
 {{ :gt3:loads:search:search-17.png?nolink |}}
-The results grid is immediately grouped and sorted by Customer Name:
+The results grid is immediately sorted and grouped by Customer Name:
 {{ :gt3:loads:search:search-18.png?nolink |}}
-To report on subtotals for the sale values of the displayed loads, scroll if necessary to display the //Customer Load Total// column. Right-click the column heading and select **Show totals for this column** from the popup menu:
+You can have multiple grouping columns. To remove grouping for a single column right-click the column heading and select **Don't Group By This Column** from the popup menu, or to remove all groupings select **Remove Grouping**.
+=====Adding Subtotals For Numeric Columns=====
+You can show subtotals for any column that contains numeric values, and you can have multiple subtotal columns. For example, to report on subtotals for the sale values of the displayed loads, scroll horizontally if necessary to display the //Customer Load Total// column. Right-click the column heading and select **Show totals for this column** from the popup menu:
 {{ :gt3:loads:search:search-19.png?nolink |}}
@@ Line 39: / Line 45: @@
 {{ :gt3:loads:search:search-20.png?nolink |}}
-You can have multiple grouping columns and multiple subtotal columns. To remove a subtotal, right-click the column heading for that column and select **Remove totals for this column** from the popup menu. To remove grouping for a single column right-click the column heading and select **Don't Group By This Column** from the popup menu, or to remove all groupings select **Remove Grouping**. Removing a grouping also removes subtotals for that column, if activated. Removing all groupings also removes all subtotals, if activated.
+To remove a subtotal, right-click the column heading for that column and select **Remove totals for this column** from the popup menu. Removing a grouping also removes subtotals for that column, if activated. Removing all groupings also removes all subtotals, if activated.
+=====Opening a Load=====
-=====Adding Subtotals For Numeric Columns=====
+You can open a specific load from the results grid by double-clicking on it, or selecting it and clicking the **Open Load** button.
 =====Printing or Exporting the Results=====
+Display or print a summary report of the displayed loads by clicking the **Print Summary** button.
+If you have Microsoft® Excel® installed, you can also click the **Export to Excel** button to create a new spreadsheet containing all the data currently populating the results grid, exactly as shown (ie including any grouping and subtotals that have been configured). This provides you the opportunity to customise the results with other calculations and/or produce a report to your own design.
 {{:gt3:loads:search:blank.png?nolink&10|}}
@@ Line 54: / Line 66: @@
 {{:gt3:loads:search:blank.png?nolink&5|}}
-Back: <-[[gt3:loads:search:filters|]]
+[[gt3:loads:search|]] · Back: <-[[gt3:loads:search:filters|]]