True Demo Demo E:\Demo.xml E:\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 DataSource1 Country,System.Object CategoryName,System.Object UnitsInStock,System.Decimal DataSource1 CrossTab1 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 ,minValue,minValue,System.Decimal,_x0030_,False,False EngineV1 DoublePass None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,1.2 Transparent 0,0,19,1.2 Arial,22,Bold Center 0,0,0,0 Text5 Cross-Tab SaddleBrown Expression Center ReportTitleBand1 if (IsFirstPass) { minValue = DataSource1.UnitsInStock; hashT[DataSource1.Country] = minValue; } All;Black;1;Solid;False;4;Black Transparent 0,2.4,19,0 {DataSource1.Country} GroupHeaderBand1 if (IsFirstPass) { if (DataSource1.UnitsInStock < minValue) { hashT.Remove(DataSource1.Country); hashT.Add(DataSource1.Country, DataSource1.UnitsInStock); } } Transparent 0,3.2,19,0 DataSource1 DataDataSource1 ASC Country Transparent 2.8,3.6,12.6,10.2 Country Top, Left;Peru;1;Solid;False;4;Black Wheat 0,3.2,1.8,0.6 {Products.Suppliers.Country} Arial,12 e9e97947-750e-493b-8716-705709e59403 0,0,0,0 CrossTab1_Row1 AllowMove, AllowResize, AllowSelect, AllowChange Country SaddleBrown 1d6e8e4d-f657-490e-a2e4-e06ac5ef9d93 {Products.Suppliers.Country} CategoryName Top, Left;Peru;1;Solid;False;4;Black Wheat 1.8,0,0.8,3.2 {Products.Categories.CategoryName} Arial,12 c49e0533-0056-4240-8cf7-8d76f8e2f80d 0,0,0,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange CategoryName SaddleBrown 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;Chocolate;1;Solid;False;4;Black White 1.8,3.2,0.8,0.6 _x007B__x0021_IsFirstPass_x0020__x0026__x0026__x0020_tag_x0020__x0021__x003D__x0020_null_x0020__x0026__x0026__x0020__x0028_decimal_x0029_hashT_x005B_tag_x005D__x0020__x003D__x003D__x0020_value_x007D_,Red,Transparent,Arial_x002C_8,True,False,,,All,TextColor Arial,10 008c850f-d8e8-4fb3-b36c-b34420adbbbf False Right 0,0,0,0 CrossTab1_Sum1 - //decimal value = 0; //if (decimal.TryParse(e.Text, out value)) //{ // if (value > 100) // e.Cell.Field.Brush = new StiSolidBrush(Color.Red); //} AllowMove, AllowResize, AllowSelect, AllowChange {Products.Suppliers.Country} 0 Black DataColumn {Products.UnitsInStock} All;Chocolate;1;Solid;False;4;Black OldLace 0,3.8,1.8,0.6 Arial,10 1d6e8e4d-f657-490e-a2e4-e06ac5ef9d93 0,0,0,0 CrossTab1_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;Chocolate;1;Solid;False;4;Black OldLace 2.6,0,1.2,3.2 Arial,10 e940d816-e320-4ba8-b3a8-3a5a9156868d 0,0,0,0 CrossTab1_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black Products CrossTab1 941bf1424f8146f7af2973cd3027449b 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/11/2011 1:06:32 PM 5/29/2004 10:59:00 AM E:\SampleCrossTab.mrt 115f8d30a13e467e836c1b98ed4058c5 Report Centimeters 2011.1.911 CSharp