Demo Demo D:\Demo.xml D:\Demo.xsd Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Categories Demo.Categories Countries CountriesID,System.Int32 Flag,System.Byte[] CountryName,System.String Countries Demo.Countries 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 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,25.9,1.4 Transparent 0,0,19,1.4 Arial,22,Bold Center 0,0,0,0 Text5 Cross-Tab with Two Summaries SaddleBrown Center ReportTitleBand1 Transparent 0,2,25.8,7.4 All;[145:122:79];1;Solid;False;4;Black [255:255:229] 0,5.9,9.8,1.2 Arial,10 82a2bcb8-8a73-409e-a93e-6f15a386ba51 Center 0,0,0,0 CrossTab1_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[145:122:79];1;Solid;False;4;Black [255:255:229] 1.8,4.7,8,1.2 Arial,10 8b687aaf-f707-432d-a389-0dd496a48cf8 Center 0,0,0,0 CrossTab1_RowTotal2 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[145:122:79];1;Solid;False;4;Black [255:255:229] 10.65,0.45,1.4,3 Arial,10 1c845f0d-2b18-49e0-af6d-3d852684e84e Center 0,0,0,0 CrossTab1_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[145:122:79];1;Solid;False;4;Black Wheat 0,0.45,1.8,3 Arial,8 f91e7e4a-e537-4b71-9b1f-5d1d7a0811f9 Center 0,0,0,0 CrossTab1_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange Country [95:72:29] Row:CrossTab1_Row1 All;[145:122:79];1;Solid;False;4;Black Wheat 1.8,0.45,8,3 Arial,8 c04c3180-2f1c-4745-8fbd-5589b784d943 Center 0,0,0,0 CrossTab1_Row2_Title AllowMove, AllowResize, AllowSelect, AllowChange CompanyName [95:72:29] Row:CrossTab1_Row2 All;[145:122:79];1;Solid;False;4;Black Wheat 0,0,9.8,0.4 Arial,8 9531d4f2-ec57-4b35-9ee4-b4c92d4401b9 Center 0,0,0,0 CrossTab1_LeftTitle AllowMove, AllowResize, AllowSelect, AllowChange Products [95:72:29] LeftTitle All;[145:122:79];1;Solid;False;4;Black Wheat 9.85,0,2.2,0.4 Arial,8 81a6fbe5-0f6e-4711-9325-d4a2c4d3b733 Center 0,0,0,0 CrossTab1_RightTitle AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [95:72:29] RightTitle All;[145:122:79];1;Solid;False;4;Black Wheat 5,3.5,4.8,0.6 Arial,8 64c912d936524ef088f1e646c22141e3 Center 0,0,0,0 CrossTab1_SumHeader1 if (tmpTbl[e.Row].ToString() == "Ma Maison") e.Cell.Field.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red); AllowMove, AllowResize, AllowSelect, AllowChange {Products.Suppliers.CompanyName} 1 [95:72:29] Expression Country Top, Left;[145:122:79];1;Solid;False;4;Black Wheat 0,3.5,1.8,2.4 {Products.Suppliers.Country} Arial,12 d0e6ada7-1c20-4aaf-a9b3-6b2c71e5be80 Center 0,0,0,0 CrossTab1_Row1 AllowMove, AllowResize, AllowSelect, AllowChange Country [95:72:29] 82a2bcb8-8a73-409e-a93e-6f15a386ba51 {Products.Suppliers.Country} CompanyName Top, Left;[145:122:79];1;Solid;False;4;Black Wheat 1.8,3.5,3.2,1.2 {Products.Suppliers.CompanyName} Arial,12 2780e357-93b9-4954-9df0-2f23fd43cd32 Left 0,0,0,0 8,0 CrossTab1_Row2 tmpTbl.Add(e.Row, e.Text); AllowMove, AllowResize, AllowSelect, AllowChange {Products.Suppliers.CompanyName} CompanyName [95:72:29] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, 8b687aaf-f707-432d-a389-0dd496a48cf8 {Products.Suppliers.CompanyName} CategoryName Top, Left;[145:122:79];1;Solid;False;4;Black Wheat 9.85,0.45,0.8,3 {Products.Categories.CategoryName} Arial,12 d9f8ccda-5577-4816-bdb8-aa35c8c22466 Center 0,0,0,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [95:72:29] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=False, Angle=90, FirstTabOffset=40, DistanceBetweenTabs=20, 1c845f0d-2b18-49e0-af6d-3d852684e84e {Products.Categories.CategoryName} UnitsInStock Top, Left, Right;[145:122:79];1;Solid;False;4;Black [255:255:255] 9.85,3.5,0.8,0.6 Arial,10 ff7b84be-83fe-4d9e-b6ab-bdfcab2eb5db 0,0,0,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black {Products.UnitsInStock} UnitPrice Left, Right, Bottom;[145:122:79];1;Solid;False;4;Black [255:255:255] 9.85,4.1,0.8,0.6 Arial,10 7527e6c7-10d4-4bb0-82ca-cf1d2b041ca4 0,0,0,0 CrossTab1_Sum2 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black {Products.UnitPrice} All;[145:122:79];1;Solid;False;4;Black Wheat 5,4.1,4.8,0.6 Arial,8 a470d8dca972471e89cc3c0082e908de Center 0,0,0,0 CrossTab1_SumHeader2 if (tmpTbl[e.Row - 1].ToString() == "Ma Maison") e.Cell.Field.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red); AllowMove, AllowResize, AllowSelect, AllowChange 2 [95:72:29] 9 Products CrossTab1 bfdb2f2371aa4d1189a88b40bc4cac44 1,1,1,1 Page1 Landscape 21.6 27.9 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Base.Dll Stimulsoft.Controls.Dll Stimulsoft.Report.Dll Cross-Tab with Two Summaries 9/29/2011 4:13:07 PM 5/29/2004 10:59:00 AM This sample demonstrates how to create a report using a Cross-tab component with two summaries. E:\CrossTabWithTwoSummaries.mrt aa9032ba596d4bde96b893cc533236c6 Report Centimeters 2011.2.1100 CSharp