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 f19f077bdda64e329e902139dad61562 Right 0,0,0,0 Text24 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 aff381832c004d9db9b11aedf908e94b 0,0,0,0 Text23 Cross-Tab with Detailing [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 968cbb0b13b3471889b522a92e89e9cd 0,0,0,0 Text25 {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 3132d5b1519a41569bcd65267d86583d Right 0,0,0,0 Text26 Date: {Today.ToString("Y")} [102:77:38] yyyy, MMMM ,,,,WordWrap=True,A=0 Expression 243035cc015149deb3eb2d85902fe31d ReportTitleBand2 Transparent 3.6,3.4,11.8,6.4 All;[142:134:121];1;Solid;False;4;Black [255:255:255] 0,4.1,1.8,0.6 CrossTab Arial,10 1d6e8e4d-f657-490e-a2e4-e06ac5ef9d93 0,0,0,0 CrossTab1_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[142:134:121];1;Solid;False;4;Black [255:255:255] 2.65,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,1.8,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,1.8,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 Country Top, Left;[142:134:121];1;Solid;False;4;Black [242:234:221] 0,3.5,1.8,0.6 CrossTab {Products.Suppliers.Country} Arial,12 e9e97947-750e-493b-8716-705709e59403 True 7e6d20a88d5c4d43a4d8a6cdadcf109d Products.Suppliers.Country Country "Country - " + Products.Suppliers.Country ReportAlias 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] 1.85,0.45,0.8,3 CrossTab {Products.Categories.CategoryName} Arial,12 c49e0533-0056-4240-8cf7-8d76f8e2f80d True 09ee7a39aa1943d5b570c2a136ed0356 Products.Categories.CategoryName CategoryName "Category - " + Products.Categories.CategoryName ReportAlias 0,0,0,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [92:84:71] ,,,,,Angle=90 e940d816-e320-4ba8-b3a8-3a5a9156868d {Products.Categories.CategoryName} UnitsInStock All;[142:134:121];1;Solid;False;4;Black [255:255:255] 1.85,3.5,0.8,0.6 CrossTab Arial,10 008c850f-d8e8-4fb3-b36c-b34420adbbbf True 047e15eb11f64c5ca70253b57a4c229a Products.Categories.CategoryName CategoryName Products.Suppliers.Country Country "Cell - " +Products.Categories.CategoryName + ", " + Products.Suppliers.Country ReportAlias 0,0,0,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black {Products.UnitsInStock} All;[142:134:121];1;Solid;False;4;Black [242:234:221] 1.85,0,2.2,0.4 CrossTab Arial,8 9c5faed6-091f-4d6e-9ce0-75efb125099f 0,0,0,0 CrossTab1_RightTitle AllowMove, AllowResize, AllowSelect, AllowChange CategoryName [92:84:71] RightTitle -1 Products Center CrossTab1 71e6f3c9dd884ec59fea9cfad05918bd 1,1,1,1 CrossTabPage 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,2.4 True None;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,19,2.4 Title1 Arial,19 Center 0,0,0,0 FooterProducts_ProductName Category - <b>{this["CategoryName"]}</b><br> Country - <b>{this["Country"]}</b> [193:152:89] ,,,,WordWrap=True,A=0 Wysiwyg Expression Center Header1 Transparent 0,3.6,19,0.6 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,8.2,0.6 Header3 Arial,9,Bold Center 0,0,0,0 HeaderProducts_ProductName ProductName [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 8.2,0,4.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 HeaderProducts_QuantityPerUnit Quantity per Unit [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 12.6,0,3.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 HeaderProducts_UnitPrice Unit Price [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 16,0,3,0.6 Header3 Arial,9,Bold Center 0,0,0,0 HeaderProducts_UnitsInStock Units in Stock [193:152:89] ,,,,WordWrap=True,A=0 Center HeaderProducts Transparent 0,5,19,0.6 Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,8.2,0.6 Data1 Arial,9 0,0,0,0 DataProducts_ProductName {Products.ProductName} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 8.2,0,4.4,0.6 Data1 Arial,9 Center 0,0,0,0 DataProducts_QuantityPerUnit {Products.QuantityPerUnit} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 12.6,0,3.4,0.6 Data1 Arial,9 Right 0,0,0,0 DataProducts_UnitPrice {Products.UnitPrice} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 16,0,3,0.6 Data1 Arial,9 Right 0,0,0,0 DataProducts_UnitsInStock {Products.UnitsInStock} [102:77:38] ,,,,WordWrap=True,A=0 Center Products Data2 _x007B__x0028_string_x0029_this_x005B__x0022_CategoryName_x0022__x005D__x0020__x003D__x003D__x0020_Products.Categories.CategoryName_x0020__x0026__x0026__x0020__x0028_string_x0029_this_x005B__x0022_Country_x0022__x005D__x0020__x003D__x003D__x0020_Products.Suppliers.Country_x000D__x000A__x007D_ DataProducts ASC ProductName Transparent 0,6.4,19,0.6 All;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,19,0.6 Footer1 Arial,9 365d42112e4b46179ffc7fbb3c4e8da3 Right 0,0,0,0 Text1 Units in Stock: {Sum(DataProducts,Products.UnitsInStock)} [102:77:38] ,,,,WordWrap=True,A=0 Expression Center Footer1 047e15eb11f64c5ca70253b57a4c229a 1,1,1,1 CellDetails 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,1.2 True None;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,19,1.2 Title1 Arial,19 Center 0,0,0,0 Text2 Country - <b>{this["Country"]}</b> [193:152:89] ,,,,WordWrap=True,A=0 Wysiwyg Expression Center HeaderBand1 Transparent 0,2.4,19,0.6 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,8.2,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text3 ProductName [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 8.2,0,4.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text4 Quantity per Unit [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 12.6,0,3.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text6 Unit Price [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 16,0,3,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text7 Units in Stock [193:152:89] ,,,,WordWrap=True,A=0 Center HeaderBand2 Left, Right;Black;1;Solid;False;4;Black Transparent 0,3.8,19,0.6 Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,8.2,0.6 Data1 Arial,9 0,0,0,0 Text8 {Products.ProductName} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 8.2,0,4.4,0.6 Data1 Arial,9 Center 0,0,0,0 Text9 {Products.QuantityPerUnit} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 12.6,0,3.4,0.6 Data1 Arial,9 Right 0,0,0,0 Text10 {Products.UnitPrice} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 16,0,3,0.6 Data1 Arial,9 Right 0,0,0,0 Text11 {Products.UnitsInStock} [102:77:38] ,,,,WordWrap=True,A=0 Center Products Data2 _x007B__x0028_string_x0029_this_x005B__x0022_Country_x0022__x005D__x0020__x003D__x003D__x0020_Products.Suppliers.Country_x000D__x000A__x007D_ DataBand1 ASC ProductName Transparent 0,5.2,19,0.6 All;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,19,0.6 Footer1 Arial,9 365d42112e4b46179ffc7fbb3c4e8da3 Right 0,0,0,0 Text12 Units in Stock: {Sum(DataBand1,Products.UnitsInStock)} [102:77:38] ,,,,WordWrap=True,A=0 Expression Center FooterBand1 7e6d20a88d5c4d43a4d8a6cdadcf109d 1,1,1,1 RowDetails 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,1.2 True None;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,19,1.2 Title1 Arial,19 Center 0,0,0,0 Text13 Category - <b>{this["CategoryName"]}</b><br> [193:152:89] ,,,,WordWrap=True,A=0 Wysiwyg Expression Center HeaderBand3 Transparent 0,2.4,19,0.6 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,8.2,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text14 ProductName [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 8.2,0,4.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text15 Quantity per Unit [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 12.6,0,3.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text16 Unit Price [193:152:89] ,,,,WordWrap=True,A=0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 16,0,3,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text17 Units in Stock [193:152:89] ,,,,WordWrap=True,A=0 Center HeaderBand4 Transparent 0,3.8,19,0.6 Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,8.2,0.6 Data1 Arial,9 0,0,0,0 Text18 {Products.ProductName} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 8.2,0,4.4,0.6 Data1 Arial,9 Center 0,0,0,0 Text19 {Products.QuantityPerUnit} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 12.6,0,3.4,0.6 Data1 Arial,9 Right 0,0,0,0 Text20 {Products.UnitPrice} [102:77:38] ,,,,WordWrap=True,A=0 Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 16,0,3,0.6 Data1 Arial,9 Right 0,0,0,0 Text21 {Products.UnitsInStock} [102:77:38] ,,,,WordWrap=True,A=0 Center Products Data2 _x007B__x0028_string_x0029_this_x005B__x0022_CategoryName_x0022__x005D__x0020__x003D__x003D__x0020_Products.Categories.CategoryName_x007D_ DataBand2 ASC ProductName Transparent 0,5.2,19,0.6 All;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,19,0.6 Footer1 Arial,9 365d42112e4b46179ffc7fbb3c4e8da3 Right 0,0,0,0 Text22 Units in Stock: {Sum(DataBand2,Products.UnitsInStock)} [102:77:38] ,,,,WordWrap=True,A=0 Expression Center FooterBand2 09ee7a39aa1943d5b570c2a136ed0356 1,1,1,1 ColumnDetails 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 Drill-Down Cross-Tab 3/26/2011 8:51:38 AM 5/29/2004 10:59:00 AM This sample demonstrates how to use drill-down functions with the Cross-Tab component. C:\Stimulsoft\Demo\Bin\Reports\DrillDownCrossTab.mrt b877cfc0af7944a38e87480069dc9b49 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