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,2 Bottom;[193:152:89];1;Solid;False;4;Black Transparent 9.4,0,9.6,0.8 Title1 Arial,19 e62fa41d3aa94fda9fd3a20addba8b2b 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 8bbbee79963d452e9b772e2fe57b5ec1 0,0,0,0 Text23 Cross-Tab with Collapsing [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 e290fa2d2c8b467291f236f2adbc66b7 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 7fef025c1d0144a1a1955e293bdedaea Right 0,0,0,0 Text18 Date: {Today.ToString("Y")} [102:77:38] yyyy, MMMM ,,,,WordWrap=True,A=0 Expression 4e1ef410f61d4c2289bd59984d8355c7 ReportTitleBand2 Transparent 0,2.8,19,2.6 All;[142:134:121];1;Solid;False;4;Black [255:255:255] 0,1.7,6.2,0.6 CrossTab Arial,10 89e2cf6e-a131-43b1-9818-4f84b8503c2f 0,0,0,0 CrossTab1_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Wysiwyg All;[142:134:121];1;Solid;False;4;Black [255:255:255] 3,1.1,3.2,0.6 CrossTab Arial,10 ca85e2e8-a344-47b9-bf94-bbbefa88ff83 0,0,0,0 CrossTab1_RowTotal2 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Wysiwyg All;[142:134:121];1;Solid;False;4;Black [242:234:221] 0,0.05,3,0.4 CrossTab Arial,8 a70b5206-143f-41fb-8574-ce48aff8f4a4 0,0,0,0 CrossTab1_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [92:84:71] Wysiwyg Row:CrossTab1_Row1 All;[142:134:121];1;Solid;False;4;Black [242:234:221] 3,0.05,3.2,0.4 CrossTab Arial,8 824d661f-3d8b-4f42-b886-878c592298de 0,0,0,0 CrossTab1_Row2_Title AllowMove, AllowResize, AllowSelect, AllowChange CompanyName [92:84:71] Wysiwyg Row:CrossTab1_Row2 CategoryName Top, Left;[142:134:121];1;Solid;False;4;Black [242:234:221] 0,0.5,3,1.2 CrossTab {Products.Categories.CategoryName} Arial,12 76fc96ab-ce10-4869-ab4a-05bfbffa518e Left True 20,0,0,0 CrossTab1_Row1 AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [92:84:71] ,,,,WordWrap=True,A=0 Wysiwyg 89e2cf6e-a131-43b1-9818-4f84b8503c2f {Products.Categories.CategoryName} CompanyName Top, Left;[142:134:121];1;Solid;False;4;Black [242:234:221] 3,0.5,3.2,0.6 CrossTab {Products.Suppliers.CompanyName} Arial,12 5824cecc-3337-419a-ba2d-43001f3d95ff Left 0,0,0,0 CrossTab1_Row2 AllowMove, AllowResize, AllowSelect, AllowChange CompanyName [92:84:71] ,,,,WordWrap=True,A=0 Wysiwyg ca85e2e8-a344-47b9-bf94-bbbefa88ff83 {Products.Suppliers.CompanyName} UnitsInStock All;[142:134:121];1;Solid;False;4;Black [255:255:255] 6.25,0.5,4,0.6 CrossTab Arial,10 7128eaa1-8a85-41a4-b4b2-46bd3b42ca42 0,0,0,0 4,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black Wysiwyg {Products.UnitPrice} All;[142:134:121];1;Solid;False;4;Black [242:234:221] 6.25,0.05,4,0.4 CrossTab Arial,8 3f9e1e1f-7083-4bcc-bf63-76ce851bad94 0,0,0,0 CrossTab1_SummaryTitle AllowMove, AllowResize, AllowSelect, AllowChange UnitsInStock [92:84:71] Wysiwyg SummaryTitle -1 Products Center CrossTab1 ef5541071c9d48c5abd18f0bfdb70514 1,1,1,1 Page1 29.7 21 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 Collapsing 11/27/2012 9:57:12 AM 5/29/2004 10:59:00 AM This sample demonstrates how to use a CrossTab with collapsing. C:\Stimulsoft\Demo\Bin\Reports\CrossTabWithCollapsing.mrt 431f9a4815fa4c7583c4c7ca1955ebc9 Report Centimeters 2016.1.28 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 True True All;[193:152:89];1;Solid;False;4;Black [242:234:221] Arial,9,Bold Center Header3 [193:152:89] Center False All;[193:152:89];1;Solid;False;4;Black Transparent Arial,9,Bold Center Header4 [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 242, 234, 221 CrossTab