Connection Connection C:\Program Files\Stimulsoft Reports.Ultimate 2011.1 Trial\Bin\Data\Demo.xml C:\Program Files\Stimulsoft Reports.Ultimate 2011.1 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 Orders OrderID Orders OrdersOrderDetails OrderID Products ProductID Products ProductsOrderDetails ProductID Customers CustomerID Customers CustomersOrders CustomerID Employees EmployeeID Employees EmployeesOrders EmployeeID Shippers ShipVia Shippers ShippersOrders ShipperID Categories CategoryID Categories CategoriesProducts CategoryID Suppliers SupplierID Suppliers SuppliersProducts SupplierID ,storedValue,storedValue,System.Decimal,,False,False ,storedObject,storedObject,System.Object,,False,False ,storedCount,storedCount,System.Int32,,False,False EngineV2 StiText text = storedObject as StiText; if (text != null) { text.Text = string.Format("CountRunning = {0}, GroupSumRunning = {1:N2}", storedCount, storedValue); } None;Black;2;Solid;False;4;Black Transparent [250:206:170] 0,26.9,19,0.8 Transparent True 7.4,0,11.6,0.8 Arial,12,Bold storedObject = sender; 9e0667afe87a4fac842d85a3101b9286 Center 0,0,0,0 Text2 place for GroupSumRunning Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center PageFooterBand1 ExceptLastPage Transparent 0,0.4,19,5.4 Transparent 0,0,19,1.8 Arial,22 Center 0,0,0,0 Text6 CountRunning and SumRunning for Groups Black Expression Center Transparent 0,1.8,19,3 Arial,14 0,0,0,0 Text7 Used scripts in events: - GetValue of Text2: store instance of Text2 to the storedObject variable. - AfterPrint of GroupHeader1: reset count and sum for new group. - AfterPrint of DataOrders: calculate count and sum values. - AfterPrint of page: write values to the storedObject. Black Expression ReportTitleBand1 storedValue = 0; storedCount = 0; Transparent 0,6.6,19,0.8 Transparent True 0,0,19,0.8 Arial,12,Bold 415aca2efef34a4d90d3b62373454cdd 0,0,0,0 Text1 Group - {Orders.EmployeeID} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center {Orders.EmployeeID} GroupHeader1 [210:234:240] 0,8.2,19,0.8 Transparent 0,0,3.2,0.8 Arial,10,Bold Center 0,0,0,0 HeaderOrders_OrderID OrderID Black Center Transparent 3.2,0,3.2,0.8 Arial,10,Bold Center 0,0,0,0 HeaderOrders_CustomerID CustomerID Black Center Transparent 6.4,0,3.2,0.8 Arial,10,Bold Center 0,0,0,0 HeaderOrders_OrderDate OrderDate Black Center Transparent 9.6,0,3,0.8 Arial,10,Bold Center 0,0,0,0 HeaderOrders_Freight Freight Black Center Transparent 16.4,0,2.6,0.8 Arial,10,Bold 728b4ae408db4d908f02dba8f8c5b807 Center 0,0,0,0 Text8 SumRunning Black Expression Center Transparent 13.8,0,2.6,0.8 Arial,10,Bold 0c683d19ee484e9e83ebeb9e48358caa Center 0,0,0,0 Text9 CountRunning Black Expression Center HeaderOrders storedValue += Orders.Freight; storedCount++; Transparent 0,9.8,19,0.6 Transparent True 0,0,3.2,0.6 Arial,8 True 0,0,0,0 DataOrders_OrderID {Orders.OrderID} Black Center Transparent True 3.2,0,3.2,0.6 Arial,8 True 0,0,0,0 DataOrders_CustomerID {Orders.CustomerID} Black Center Transparent True 6.4,0,3.2,0.6 Arial,8 True 0,0,0,0 DataOrders_OrderDate {Orders.OrderDate} Black Center Transparent True 9.6,0,2,0.6 Arial,8 True Right 0,0,0,0 DataOrders_Freight {Orders.Freight} Black Center Transparent True 14.2,0,2.2,0.6 Arial,8 True f4a4c4dffea34071bfa4f135146cdf84 Center 0,0,0,0 Text3 {storedCount + 1} Black Expression Center Transparent True 16.4,0,2.6,0.6 Arial,8 True 0b6d808dd54f42e8ae13859cf540f3df Right 0,0,0,0 Text4 {storedValue + Orders.Freight} Black Expression Center Orders DataOrders Style1 [206:221:176] 0,11.2,19,0.8 Transparent True 6.4,0,12.6,0.8 Arial,12,Bold 17ee2e032c08462f872d979be7e8ef0a Right 0,0,0,0 Text5 Count of group = {Count()} Sum of group = {storedValue} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center GroupFooter1 30960a72157e4c809506cc5e93b34234 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.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 9/12/2011 3:01:14 PM 11/23/2010 1:01:32 AM C:\Users\HighAley\AppData\Roaming\QIP\Profiles\highaley\RcvdFiles\Ishma_332528756\GroupSumRunning.mrt 98bc632a6c6b4965a4ab9d522a60f0bd Report Centimeters 2011.2.1028 CSharp PapayaWhip Arial,8 Style1 None Black