Demo Demo D:\Demo.xml D:\Demo.xsd 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 DoublePass None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,11.8,6.4 All;[142:134:121];1;Solid;False;4;Black [255:255:255] 0,4.7,2.2,1.2 CrossTab Arial,10 1d6e8e4d-f657-490e-a2e4-e06ac5ef9d93 0,0,0,0 CrossTab1_RowTotal1 if (IsFirstPass) ht[e.Column] = e.Cell.Value; AllowMove, AllowResize, AllowSelect, AllowChange {Products.Categories.CategoryName} Total Black All;[142:134:121];1;Solid;False;4;Black [255:255:255] 3.05,0.45,1.4,3 CrossTab Arial,10 e940d816-e320-4ba8-b3a8-3a5a9156868d 0,0,0,0 CrossTab1_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[142:134:121];1;Solid;False;4;Black [242:234:221] 0,0.45,2.2,3 CrossTab Arial,8 43da8e96-4db5-42c3-8bcc-892b578368d0 0,0,0,0 CrossTab1_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange Country [92:84:71] Row:CrossTab1_Row1 All;[142:134:121];1;Solid;False;4;Black [242:234:221] 0,0,2.2,0.4 CrossTab Arial,8 c73d4241-bf78-4c4e-94f6-5845bc904803 0,0,0,0 CrossTab1_LeftTitle AllowMove, AllowResize, AllowSelect, AllowChange Products [92:84:71] LeftTitle All;[155:155:155];1;Solid;False;4;Black White 1.8,3.5,0.4,0.6 Arial,8 62e3bff1e9e64ce9967e1354d6ee8ea0 0,0,0,0 CrossTab1_SumHeader1 AllowMove, AllowResize, AllowSelect, AllowChange 1 [105:105:105] All;[155:155:155];1;Solid;False;4;Black White 1.8,4.1,0.4,0.6 Arial,8 dae40f43de724b62b086020c1aefc7c0 0,0,0,0 CrossTab1_SumHeader2 AllowMove, AllowResize, AllowSelect, AllowChange 2 [105:105:105] All;[155:155:155];1;Solid;False;4;Black White 2.25,0,2.2,0.4 Arial,8 61f0de96b262467bafef14c42eb1db5e 0,0,0,0 CrossTab1_RightTitle AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [105:105:105] RightTitle Country Top, Left;[142:134:121];1;Solid;False;4;Black [242:234:221] 0,3.5,1.8,1.2 CrossTab {Products.Suppliers.Country} Arial,12 e9e97947-750e-493b-8716-705709e59403 0,0,0,0 CrossTab1_Row1 AllowMove, AllowResize, AllowSelect, AllowChange Country [92:84:71] 1d6e8e4d-f657-490e-a2e4-e06ac5ef9d93 {Products.Suppliers.Country} CategoryName Top, Left;[142:134:121];1;Solid;False;4;Black [242:234:221] 2.25,0.45,0.8,3 CrossTab {Products.Categories.CategoryName} Arial,12 c49e0533-0056-4240-8cf7-8d76f8e2f80d 0,0,0,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [92:84:71] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=False, Angle=90, FirstTabOffset=40, DistanceBetweenTabs=20, e940d816-e320-4ba8-b3a8-3a5a9156868d {Products.Categories.CategoryName} UnitsInStock All;[142:134:121];1;Solid;False;4;Black [255:255:255] 2.25,3.5,0.8,0.6 CrossTab Arial,10 008c850f-d8e8-4fb3-b36c-b34420adbbbf 0,0,0,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black {Products.UnitsInStock} UnitsInStock All;[155:155:155];1;Solid;False;4;Black White 2.25,4.1,0.8,0.6 Arial,8 005663e9792f41dc95f08dfb4fd3c591 0,0,0,0 CrossTab1_Sum2 if (IsSecondPass) e.Text = (Math.Round((decimal)Cells[ 0, -1] / (decimal)ht[e.Column] * 100, 2)).ToString(); AllowMove, AllowResize, AllowSelect, AllowChange True 0 Black {Products.UnitsInStock} -1 Products Center CrossTab1 71e6f3c9dd884ec59fea9cfad05918bd 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 Standard Cross-Tab 2/21/2014 10:35:17 AM 5/29/2004 10:59:00 AM This sample demonstrates how to create a report using a Cross-tab component. D:\StandardCrossTabPercentByColumn.mrt 270d3fde7f4e469d8c4ce495789c314a Report Centimeters 2014.1.1811 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 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