PRODUCT LIST SORTED BY GROUP TOTAL
Demonstrates how to sort groups by the total value of a group. To create this report:

- create the group report similar to the "General/Groups" report;

- make it two-pass ("Report/Options..." menu, "Double pass" checkbox);

- add the GroupFooter1.BeforePrint script that will calculate and remember the total value for each group on the first pass;

- add the GroupRank method that will return the calculated total value for each group on the second pass;

- turn off the sort in the group header's editor;

- invoke the data band's editor and set sort by GroupRank(), then by ProductName.

 
G
 
Geitost
$2.50
 
Genen Shouyu
$15.50
 
Gnocchi di nonna Alice
$38.00
 
Gorgonzola Telino
$12.50
 
Grandma's Boysenberry Spread
$25.00
 
Gravad lax
$26.00
 
Guaraná Fantástica
$4.50
 
Gudbrandsdalsost
$36.00
 
Gula Malacca
$19.45
 
Gumbär Gummibärchen
$31.23
 
Gustaf's Knäckebröd
$21.00
 
Total products: 11
 
C
 
Camembert Pierrot
$34.00
 
Carnarvon Tigers
$62.50
 
Chai
$18.00
 
Chang
$19.00
 
Chartreuse verte
$18.00
 
Chef Anton's Cajun Seasoning
$22.00
 
Chef Anton's Gumbo Mix
$21.35
 
Chocolade
$12.75
 
Côte de Blaye
$263.50
 
Total products: 9
 
S
 
Sasquatch Ale
$14.00
 
Schoggi Schokolade
$43.90
 
Scottish Longbreads
$12.50
 
Singaporean Hokkien Fried Mee
$14.00
 
Sir Rodney's Marmalade
$81.00
 
Sir Rodney's Scones
$10.00
 
Sirop d'érable
$28.50
 
Spegesild
$12.00
 
Steeleye Stout
$18.00
 
Total products: 9
 
R
 
Raclette Courdavault
$55.00
 
Ravioli Angelo
$19.50
 
Page 1
Generated by FastReport .NET