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 582bd984897e4863a79224f9b8534236 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 ebdcd87698a4492eb11cdc830639d7f4 0,0,0,0 Text23 Cross-Tab without Rows [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 7b88c1e59c4c40688261e2210bf47df8 0,0,0,0 Text17 {ReportDescription} [102:77:38] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression None;[102:77:38];1;Solid;False;4;Black Transparent True 14.6,1,4.4,0.8 Title2 Arial,9 e2f8018422854d18a1506a1c763f2ccf Right 0,0,0,0 Text18 Date: {Today.ToString("Y")} [102:77:38] yyyy, MMMM HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression 8687c6fc7ac64621b5c201c52e53dbb7 ReportTitleBand2 Transparent 0,2.8,19,5.2 All;[142:134:121];1;Solid;False;4;Black [255:255:255] 5.05,0.05,1.2,3 CrossTab Arial,10 714bcfcc-a0d5-41cd-bbd1-c79141a1b8d4 Center 0,0,0,0 CrossTab1_ColTotal1 if (e.Cell.SummaryIndex == 2) { e.Value = Cells [0, -2] * Cells [0, -1] ; } AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[142:134:121];1;Solid;False;4;Black [242:234:221] 0,0.05,5,3 CrossTab Arial,8 a645c466-50eb-4e93-9f65-1bf556ddb88d Center 0,0,0,0 CrossTab1_Column1_Title AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [92:84:71] Col:CrossTab1_Column1 All;[142:134:121];1;Solid;False;4;Black [242:234:221] 0,3.1,3,1.8 CrossTab Arial,8 f5fe92ba-55b8-48c1-82a1-f64b1a6bd723 Center 0,0,0,0 CrossTab1_SummaryTitle AllowMove, AllowResize, AllowSelect, AllowChange UnitsInStock, UnitPrice [92:84:71] SummaryTitle All;[142:134:121];1;Solid;False;4;Black [242:234:221] 3,3.1,0.4,0.6 CrossTab Arial,8 233cc9cabead40eaba5dbff18128b5bd Center 0,0,0,0 CrossTab1_SumHeader1 AllowMove, AllowResize, AllowSelect, AllowChange 1 [92:84:71] All;[142:134:121];1;Solid;False;4;Black [242:234:221] 3,3.7,0.4,0.6 CrossTab Arial,8 7fe10813aa054cb1a2345544172b8c5d Center 0,0,0,0 CrossTab1_SumHeader2 AllowMove, AllowResize, AllowSelect, AllowChange 2 [92:84:71] CategoryName Top, Left;[142:134:121];1;Solid;False;4;Black [242:234:221] 3.45,0.05,1.6,3 CrossTab {Products.Categories.CategoryName} Arial,12 68ab7583-8eea-495c-baeb-83372eba2a9f Center 0,0,0,0 1.6,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [92:84:71] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=90, FirstTabOffset=40, DistanceBetweenTabs=20, 714bcfcc-a0d5-41cd-bbd1-c79141a1b8d4 {Products.Categories.CategoryName} UnitsInStock All;[142:134:121];1;Solid;False;4;Black [255:255:255] 3.45,3.1,1.6,0.6 CrossTab Arial,10 539af7a0-19fd-4c49-9418-07c73b9bda62 0,0,0,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black {Products.UnitPrice} UnitPrice All;[142:134:121];1;Solid;False;4;Black [255:255:255] 3.45,3.7,1.6,0.6 CrossTab Arial,10 704a9f0a-c8a8-4263-ab8d-79cab22ee286 0,0,0,0 CrossTab1_Sum2 AllowMove, AllowResize, AllowSelect, AllowChange

Average

0 Black , 0 0 {Products.UnitPrice} UnitPrice All;[155:155:155];1;Solid;False;4;Black [255:255:255] 3.45,4.3,1.6,0.6 Arial,8 625f0596740a4697ad7937f5877de5ad 0,0,0,0 CrossTab1_Sum3 e.Value = Cells [0, -2] * Cells [0, -1] ; AllowMove, AllowResize, AllowSelect, AllowChange 0 Black ,   5 1 р. {Products.UnitPrice} All;[155:155:155];1;Solid;False;4;Black White 3,4.3,0.4,0.6 Arial,8 1448d53aaf1e4d8aa00ca59c6410b90c Center 0,0,0,0 CrossTab1_SumHeader3 AllowMove, AllowResize, AllowSelect, AllowChange 3 [105:105:105] -1 Products CrossTab1 058b433420d64545b94974efb4fe59d9 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 without Rows 9/15/2011 4:39:03 PM 5/29/2004 10:59:00 AM This sample demonstrates how to create report using a cross-tab component without rows. C:\Program Files\Stimulsoft Reports.Ultimate 2011.1 Trial\Bin\Reports\CrossTabWithoutRows.mrt f68ee67e85da4d5cb6498bee77f3b031 Report Centimeters 2011.2.1028 CSharp False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Right Title1 None [193:152:89] Center False None;[102:77:38];1;Solid;False;4;Black Transparent Arial,9 Title2 None [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Header1 None [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Center Header2 None [193:152:89] Center False True True All;[193:152:89];1;Solid;False;4;Black [242:234:221] Arial,9,Bold Center Header3 None [193:152:89] Center False All;[193:152:89];1;Solid;False;4;Black Transparent Arial,9,Bold Center Header4 None [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Data1 None [102:77:38] Center False False False False False [240:237:232] Arial,9 Data2 None Black False None;[193:152:89];1;Solid;False;4;Black [240:237:232] Arial,9 Data3 None [102:77:38] Center False Top;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Footer1 None [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Right Footer2 None [193:152:89] Center 242, 234, 221 CrossTab