Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Categories Demo.Categories Customers CustomerID,System.String CompanyName,System.String ContactName,System.String ContactTitle,System.String Address,System.String City,System.String Region,System.String PostalCode,System.String Country,System.String Phone,System.String Fax,System.String Customers Demo.Customers Employees EmployeeID,System.Int32 LastName,System.String FirstName,System.String Title,System.String BirthDate,System.DateTime HireDate,System.DateTime Address,System.String City,System.String Region,System.String PostalCode,System.String Country,System.String HomePhone,System.String Notes,System.String ReportsTo,System.Int32 Employees Demo.Employees Order Details OrderID,System.Int32 ProductID,System.Int32 UnitPrice,System.Decimal Quantity,System.Int16 Discount,System.Single Order Details Demo.Order Details Orders OrderID,System.Int32 CustomerID,System.String EmployeeID,System.Int32 OrderDate,System.DateTime RequiredDate,System.DateTime ShippedDate,System.DateTime ShipVia,System.Int32 Freight,System.Decimal ShipName,System.String ShipAddress,System.String ShipCity,System.String ShipRegion,System.String ShipPostalCode,System.String ShipCountry,System.String Orders Demo.Orders Products ProductID,System.Int32 ProductName,System.String SupplierID,System.Int32 CategoryID,System.Int32 QuantityPerUnit,System.String UnitPrice,System.Decimal UnitsInStock,System.Int16 Products Demo.Products Shippers ShipperID,System.Int32 CompanyName,System.String Phone,System.String Shippers Demo.Shippers Suppliers SupplierID,System.Int32 CompanyName,System.String ContactName,System.String ContactTitle,System.String Address,System.String City,System.String Region,System.String PostalCode,System.String Country,System.String Phone,System.String Fax,System.String HomePage,System.String Suppliers Demo.Suppliers Countries CountriesID,System.Int32 Flag,System.Byte[] CountryName,System.String Countries Demo.Countries Employees ReportsTo Employees EmployeesEmployees EmployeeID Products ProductID Products ProductsOrder_Details ProductID Orders OrderID Orders OrdersOrder_Details OrderID Customers CustomerID Customers CustomersOrders CustomerID Shippers ShipVia Shippers ShippersOrders ShipperID Employees EmployeeID Employees EmployeesOrders EmployeeID Categories CategoryID Categories CategoriesProducts CategoryID Suppliers SupplierID Suppliers SuppliersProducts SupplierID EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,1.8 Bottom;[193:152:89];1;Solid;False;4;Black Transparent 9.4,0,9.6,0.8 Title1 Arial,19 581e5a90a3014072b5c18c1424b86eb5 Right 0,0,0,0 Text20 Stimulsoft [193:152:89] Expression Center Bottom;[193:152:89];1;Solid;False;4;Black Transparent 0,0,9.4,0.8 Title1 Arial,19 de93b06949fe489485b642727373b9e2 0,0,0,0 Text23 Top Sales [193:152:89] Expression Center None;[102:77:38];1;Solid;False;4;Black Transparent True 0,1,14.6,0.8 Title2 Arial,9 16775d0f5b2843dc9355346ac831b56d 0,0,0,0 Text17 {ReportDescription} [102:77:38] ,,,,WordWrap=True,A=0 Expression None;[102:77:38];1;Solid;False;4;Black Transparent True 14.6,1,4.4,0.8 Title2 Arial,9 a25e066da83546cc908c68a94f276f82 Right 0,0,0,0 Text18 Date: {Today.ToString("Y")} [102:77:38] yyyy, MMMM ,,,,WordWrap=True,A=0 Expression d238a59b5b2c4d81b66c851d686b44ac ReportTitleBand1 Transparent 0,3,19,1.4 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0.8,5.8,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text10 Unit Name [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 5.8,0.8,3.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text2 Description [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 10.8,0.8,4.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text24 Item Price [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 15.2,0.8,3.8,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text26 Total [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 9.2,0.8,1.6,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text11 Qty [193:152:89] Expression Center None;[193:152:89];1;Solid;False;4;Black Transparent 0,0.2,10.6,0.6 Header2 Arial,12,Bold b81897a2985b4bf981bfcdb56ead6db5 0,0,0,0 Text5 {GroupLine}.{Products.Categories.CategoryName} [193:152:89] ,   5 1 р. Expression Center None;[193:152:89];1;Solid;False;4;Black Transparent 16.4,0.2,2.6,0.6 Header2 Arial,12,Bold c4106173d23545a49f6aa2a654f250bb Right 0,0,0,0 Text4 {Sum(Products.UnitsInStock * Products.UnitPrice)} [193:152:89] ,   5 1 р. Expression Center None;[193:152:89];1;Solid;False;4;Black Transparent 11.8,0.2,4.6,0.6 Header2 Arial,12,Bold 38f5b46ce18943dba72d0fcf52de7864 Right 0,0,0,0 Text7 Total: [193:152:89] ,   5 1 р. Expression Center 9.2,0.8,0,0 StartPointPrimitive3 59bef323f0d0486daa4bb8989739c2f6 10.8,0.8,0,0 StartPointPrimitive4 ab429eff0bf04281a9cd1df63dc14559 15.2,0.8,0,0 StartPointPrimitive5 b3c6de69000b4184af30078f0390cf31 0,0.8,0,0 StartPointPrimitive1 93516685aa7a45219cff379e06ac5527 5.8,0.8,0,0 StartPointPrimitive2 ab54f5a8419944bcb80b80833d639b28 {Products.Categories.CategoryName} True GroupHeaderBand1 {Products.UnitsInStock * Products.UnitPrice} Descending Transparent 0,5.2,19,0.6 None;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,5.8,0.6 Data1 Arial,9 True 0,0,0,0 Text1 {Products.ProductName} [102:77:38] ,,,,WordWrap=True,A=0 Center None;[193:152:89];1;Solid;False;4;Black Transparent 5.8,0,3.4,0.6 Data1 Arial,9 True 0,0,0,0 Text3 {Products.QuantityPerUnit} [102:77:38] Center None;[193:152:89];1;Solid;False;4;Black Transparent 10.8,0,4.4,0.6 Data1 Arial,9 True Right 0,0,0,0 Text25 {Products.UnitPrice} [102:77:38] ,   5 1 р. Center None;[193:152:89];1;Solid;False;4;Black Transparent 15.2,0,3.8,0.6 Data1 Arial,9 True Right 0,0,0,0 Text12 {Products.UnitsInStock * Products.UnitPrice} [102:77:38] ,   5 1 р. Expression Center None;[193:152:89];1;Solid;False;4;Black Transparent 9.2,0,1.6,0.6 Data1 Arial,9 True Right 0,0,0,0 Text9 {Products.UnitsInStock} [102:77:38] ,   1 Center CategoriesProducts Products Data2 DataBand1 ASC ProductName Transparent 0,6.6,19,1 All;[193:152:89];1;Solid;False;4;Black Transparent 0,0,19,0.6 Footer1 Arial,9 78c8f6300a934232a4e84edee21cecd3 Right 0,0,0,0 Text8 Count: {Count()} [102:77:38] ,   5 1 р. Expression Center 9.2,0,0,0 EndPointPrimitive3 59bef323f0d0486daa4bb8989739c2f6 10.8,0,0,0 EndPointPrimitive4 ab429eff0bf04281a9cd1df63dc14559 15.2,0,0,0 EndPointPrimitive5 b3c6de69000b4184af30078f0390cf31 19,0,0,0 EndPointPrimitive1 93516685aa7a45219cff379e06ac5527 5.8,0,0,0 EndPointPrimitive2 ab54f5a8419944bcb80b80833d639b28 GroupFooterBand1 True Transparent 0,8.4,19,1.4 Top, Right, Bottom;[193:152:89];1;Solid;False;4;Black Transparent 16.4,0.2,2.6,1.2 Footer2 Arial,12,Bold f8f69fab503548d09aa6bb7bf8a47530 Right 0,0,0,0 Text6 {Sum(Products.UnitsInStock * Products.UnitPrice)} [193:152:89] ,   5 1 р. Expression Center Top, Left, Bottom;[193:152:89];1;Solid;False;4;Black Transparent 0,0.2,16.4,1.2 Arial,12,Bold e131c92a090f4de4abac7b95be9ccc61 Right 0,0,0,0 Text14 Grand Total: [193:152:89] ,   5 1 р. Expression Center ReportSummaryBand1 5.8,3.8,0.0254,2.8 193, 152, 89 Header3 Black ab54f5a8419944bcb80b80833d639b28 VerticalLine1 Black 9.2,3.8,0.0254,2.8 193, 152, 89 Header3 Black 59bef323f0d0486daa4bb8989739c2f6 VerticalLine2 Black 10.8,3.8,0.0254,2.8 193, 152, 89 Header3 Black ab429eff0bf04281a9cd1df63dc14559 VerticalLine3 Black 15.2,3.8,0.0254,2.8 193, 152, 89 Header3 Black b3c6de69000b4184af30078f0390cf31 VerticalLine4 Black 0,3.8,19,2.8 193, 152, 89 Header3 93516685aa7a45219cff379e06ac5527 Rectangle1 366bfdc35bcf48f3aeb38f2b5f58db21 1,1,1,1 Page1 29.7 21 Arial,100,Bold [50:0:0:0] StandardAndDotMatrix 33538047 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Base.Dll Stimulsoft.Controls.Dll Stimulsoft.Report.Dll Top Sales Stimulsoft 7/13/2017 7:05:21 PM 5/29/2004 10:59:00 AM This sample demonstrates how to sort group by its totals. C:\Users\Lech\AppData\Local\Stimulsoft\demo-reports-2017.1.9\04. Reports with Groups\03. Top Sales.mrt 7da2a1a7e1aa403c8de94ac2f6bc1001 Top Sales Centimeters 2017.1.9.0 CSharp False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Right Title1 [193:152:89] Center False None;[102:77:38];1;Solid;False;4;Black Transparent Arial,9 Title2 [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Header1 [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Center Header2 [193:152:89] Center False All;[193:152:89];1;Solid;False;4;Black [242:234:221] Arial,9,Bold Center Header3 [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Data1 [102:77:38] Center False False False False [240:237:232] Arial,9 Data2 Black False None;[193:152:89];1;Solid;False;4;Black [240:237:232] Arial,9 Data3 [102:77:38] Center False Top;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Footer1 [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Right Footer2 [193:152:89] Center