Differences

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

Link to this comparison view

gt3:loads:search:grid [03/06/2021 02:11]
Ian Davidson [Adding Subtotals For Numeric Columns]
gt3:loads:search:grid [03/06/2021 02:36] (current)
Ian Davidson [Adding Subtotals For Numeric Columns]
Line 23: Line 23:
 {{ :gt3:loads:search:search-16.png?nolink |}} {{ :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 |}} {{ :gt3:loads:search:search-17.png?nolink |}}
Line 37: Line 37:
 =====Adding Subtotals For Numeric Columns===== =====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 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 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 |}} {{ :gt3:loads:search:search-19.png?nolink |}}
Line 48: Line 48:
  
  
 +
 +=====Opening a Load=====
 +
 +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===== =====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|}} {{:gt3:loads:search:blank.png?nolink&10|}}
Line 57: Line 66:
 {{:gt3:loads:search:blank.png?nolink&5|}} {{:gt3:loads:search:blank.png?nolink&5|}}
  
-Back: <-[[gt3:loads:search:filters|]]+[[gt3:loads:search|]] · Back: <-[[gt3:loads:search:filters|]]
  
gt3/loads/search/grid.1622686260.txt.gz · Last modified: 03/06/2021 02:11 by Ian Davidson
Content Copyright © 2026 CDA Software · Wiki powered by DokuWiki