Connection Connection C:\Program Files\Stimulsoft Reports.Ultimate 2011.2 Trial\Bin\Data\Demo.xml C:\Program Files\Stimulsoft Reports.Ultimate 2011.2 Trial\Bin\Data\Demo.xsd Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Picture,System.Byte[] Categories Connection.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 Connection.Customers Employees EmployeeID,System.Int32 LastName,System.String FirstName,System.String Title,System.String TitleOfCourtesy,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 Extension,System.String Photo,System.Byte[] Notes,System.String ReportsTo,System.Int32 Employees Connection.Employees Order Details OrderID,System.Int32 ProductID,System.Int32 UnitPrice,System.Decimal Quantity,System.Int16 Discount,System.Single Order Details Connection.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 Connection.Orders Products ProductID,System.Int32 ProductName,System.String SupplierID,System.Int32 CategoryID,System.Int32 QuantityPerUnit,System.String UnitPrice,System.Decimal UnitsInStock,System.Int16 UnitsOnOrder,System.Int16 ReorderLevel,System.Int16 Discontinued,System.Boolean Products Connection.Products Shippers ShipperID,System.Int32 CompanyName,System.String Phone,System.String Shippers Connection.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 Connection.Suppliers Countries CountriesID,System.Int32 Flag,System.Byte[] CountryName,System.String Countries Connection.Countries States Name,System.String USPS,System.String Population,System.Int32 Capital,System.String States Connection.States Auto Rank,System.Double Country,System.String Year2009,System.Double Year2005,System.Double Year2000,System.Double Auto Connection.Auto GlobalGrowth Region,System.String Year2006,System.Double Year2007,System.Double Year2008,System.Double Year2009,System.Double GlobalGrowth Connection.GlobalGrowth Opec Year,System.Double Iran,System.Double Iraq,System.Double Kuwait,System.Double Saudi_x0020_Arabia,System.Double UAE,System.Double Venezuela,System.Double Libya,System.Double Nigeria,System.Double Opec Connection.Opec Orders2 OrderID Orders2 OrdersOrderDetails OrderID Products2 ProductID Products2 ProductsOrderDetails ProductID EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,27.3,19,0.4 None;[193:152:89];1;Solid;False;4;Black Transparent 6.8,0,12.2,0.4 Footer1 Arial,9 ff60729d201b46a59b0591e59ec81adf Right 0,0,0,0 Text5 {PageNofM} [102:77:38] Center 6e50b07f89174c7ab50924bdfb9ca619 PageFooterBand2 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 19f97bf6cc974a31bb778e2d1ae0da24 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 0b619ef4abf9410cadedf6df0036d707 0,0,0,0 Text23 Tree with Locked Components [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 d9ed0008cf7c45a189e000f0424a5b44 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 37802c36c17d40d1bfa8d12eb1189df1 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 47c871b2f10f4ee08ef38202aefd6b79 ReportTitleBand2 Transparent 0,3.2,19,0.6 Top, Left, Bottom;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,6.2,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text10 Employee [193:152:89] Center Top, Left, Bottom;[193:152:89];1;Solid;False;4;Black [242:234:221] 6.2,0,4.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text12 DecreasingSize, OnlyInWidthOfComponent Phone [193:152:89] Center Top, Left, Bottom;[193:152:89];1;Solid;False;4;Black [242:234:221] 10.6,0,3.2,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text13 City [193:152:89] Center Top, Left, Bottom;[193:152:89];1;Solid;False;4;Black [242:234:221] 13.8,0,2.4,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text11 Region [193:152:89] Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 16.2,0,2.8,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text4 Country [193:152:89] Center HeaderBand1 True [252:230:212] 0,4.6,19,0.6 Top, Bottom;[193:152:89];1;Solid;False;4;Black Transparent 10.6,0,3.2,0.6 Data1 _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_1_x007D_,Red,White,Arial_x002C_8,True,False,,,None,BackColor _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,True,False,,Data2,None Arial,9 Center True 0,0,0,0 Text3 {Employees.City} [102:77:38] Center Top, Left, Bottom;[193:152:89];1;Solid;False;4;Black Transparent 0,0,6.2,0.6 Data1 _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_1_x007D_,Red,White,Arial_x002C_8,True,False,,,None,BackColor _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,True,False,,Data2,None Arial,9 0,0,0,0 Text1 {Employees.FirstName} {Employees.LastName} [102:77:38] Center Top, Left, Bottom;[193:152:89];1;Solid;False;4;Black Transparent 13.8,0,2.4,0.6 Data1 _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_1_x007D_,Red,White,Arial_x002C_8,True,False,,,None,BackColor _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,True,False,,Data2,None Arial,9 Center True 0,0,0,0 Text9 {level} [102:77:38] Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent 16.2,0,2.8,0.6 Data1 _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_1_x007D_,Red,White,Arial_x002C_8,True,False,,,None,BackColor _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,True,False,,Data2,None Arial,9 Center True 0,0,0,0 Text14 {Employees.Country} [102:77:38] Center All;[193:152:89];1;Solid;False;4;Black Transparent 6.2,0,4.4,0.6 Data1 _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_1_x007D_,Red,White,Arial_x002C_8,True,False,,,None,BackColor _x007B__x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,True,False,,Data2,None Arial,9 Center True 0,0,0,0 Text2 {Employees.HomePhone} [102:77:38] Center Employees level = Employees.GetLevel(); levels[level] = Employees.FirstName + Employees.LastName; levelName = "%"; for (int index = 0; index < level + 1; index++) { levelName += "\\" + levels[index]; } e.Value = levelName; EmployeeID ReportsTo HierarchicalBand1 366bfdc35bcf48f3aeb38f2b5f58db21 1,1,1,1 Page1 29.7 21 Arial,100,Bold [50:0:0:0] 33538047 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Base.Dll Stimulsoft.Controls.Dll Stimulsoft.Report.Dll Tree with Locked Components Stimulsoft 11/22/2011 3:38:16 PM 5/29/2004 10:59:00 AM This sample demonstrates how to create an hierarchical report with locked components. C:\Users\HighAley\AppData\Roaming\QIP\Profiles\highaley\RcvdFiles\Ishma_332528756\TreeWithLockedComponents 2.mrt 6e4daa809fe041c6ba11c93c01d57984 Report Centimeters 2011.3.1108 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