Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Picture,System.Byte[] False 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 False Customers Demo.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 False Employees Demo.Employees Order Details OrderID,System.Int32 ProductID,System.Int32 UnitPrice,System.Decimal Quantity,System.Int16 Discount,System.Single False 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 False 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 UnitsOnOrder,System.Int16 ReorderLevel,System.Int16 Discontinued,System.Boolean False Products Demo.Products Shippers ShipperID,System.Int32 CompanyName,System.String Phone,System.String False 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 False Suppliers Demo.Suppliers Countries CountriesID,System.Int32 Flag,System.Byte[] CountryName,System.String False Countries Demo.Countries States Name,System.String USPS,System.String Population,System.Int32 Capital,System.String False States Demo.States Auto Rank,System.Double Country,System.String Year2009,System.Double Year2005,System.Double Year2000,System.Double False Auto Demo.Auto GlobalGrowth Region,System.String Year2006,System.Double Year2007,System.Double Year2008,System.Double Year2009,System.Double False GlobalGrowth Demo.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 False Opec Demo.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 EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,13 All;Black;1;Solid;False;4;Black Transparent 0,2,11.4,0.8 Arial,14 4d9ac0e1553a48fe8613e524b4b867ae 0,0,0,0 Text10 Sum1 = {Sum(Data1,Employees.EmployeeID)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 0,2.8,11.4,0.8 Arial,14 3efd009a78734396ab775d03520e12b1 0,0,0,0 Text11 Sum2 = {Sum(Data2,Categories.CategoryID)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 0,3.6,11.4,0.8 Arial,14 4b270847849b43248b6156129a1ef5e9 0,0,0,0 Text12 Sum3 = {Sum(Data3,Products.ProductID)} Black Expression Center All;Black;1;Solid;False;4;Black [223:167:166] True 0,5.8,19,1.4 Arial,14 62e0995391cf4e55b7825788fa50d7a6 0,0,0,0 Text13 Sum1 + Sum2 + Sum3 = {Sum(Data1,Employees.EmployeeID) + Sum(Data2,Categories.CategoryID) + Sum(Data3,Products.ProductID)} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;Black;1;Solid;False;4;Black Transparent True 0,9.6,19,1.4 Arial,14 613ba7b27c0a469e8be7e275d2e5adc6 0,0,0,0 Text14 Totals.Sum1 + Totals.Sum2 + Totals.Sum3 = {Totals.Sum(Data1,Employees.EmployeeID) + Totals.Sum(Data2,Categories.CategoryID) + Totals.Sum(Data3,Products.ProductID)} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center Transparent 0,0,19,1.4 Arial,14,Bold 1f01d6b7cebd496d83d79a00d1c5e8eb Center 0,0,0,0 Text15 Calculation at the begin of the report Black Expression Center [255:242:0] 0,7.2,19,1.8 Arial,12,Bold 0,0,0,0 Text6 Unfortunately, this summarizing will be correct only after rendering of all databands. It's pecularity of engine, and we cannot fix this. So in this case please use the Totals functions. Black Expression 1 c47fa06e6aa94eaeb64fa5123e1577a5 DataBand2 Transparent 0,14.2,19,0.8 Transparent 0,0,4.8,0.8 Arial,10,Bold 0,0,0,0 HeaderEmployees_EmployeeID EmployeeID Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent 4.8,0,4.8,0.8 Arial,10,Bold 0,0,0,0 HeaderEmployees_LastName LastName Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent 9.6,0,4.8,0.8 Arial,10,Bold 0,0,0,0 HeaderEmployees_FirstName FirstName Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent 14.4,0,4.6,0.8 Arial,10,Bold 0,0,0,0 HeaderEmployees_Title Title Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center HeaderEmployees Transparent 0,15.8,19,0.8 Transparent True 0,0,4.8,0.8 Arial,8 0,0,0,0 DataEmployees_EmployeeID {Employees.EmployeeID} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 4.8,0,4.8,0.8 Arial,8 0,0,0,0 DataEmployees_LastName {Employees.LastName} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 9.6,0,4.8,0.8 Arial,8 0,0,0,0 DataEmployees_FirstName {Employees.FirstName} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 14.4,0,4.6,0.8 Arial,8 0,0,0,0 DataEmployees_Title {Employees.Title} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Employees Data1 Top;Black;1;Solid;False;4;Black Transparent 0,17.4,19,0.8 Transparent True 0,0,9.6,0.8 Arial,10,Bold d893746f930a4570a414ede3c3018f29 0,0,0,0 Text1 {Sum(Data1,Employees.EmployeeID)} Black Totals Center FooterBand1 2ec9f4c894fd4b1b8b04353a84de3282 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,0.8 Transparent 0,0,6.4,0.8 Arial,10,Bold 0,0,0,0 HeaderCategories_CategoryID CategoryID Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent 6.4,0,6.4,0.8 Arial,10,Bold 0,0,0,0 HeaderCategories_CategoryName CategoryName Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent 12.8,0,6.2,0.8 Arial,10,Bold 0,0,0,0 HeaderCategories_Description Description Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center HeaderCategories Transparent 0,2,19,0.8 Transparent True 0,0,6.4,0.8 Arial,8 0,0,0,0 DataCategories_CategoryID {Categories.CategoryID} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 6.4,0,6.4,0.8 Arial,8 0,0,0,0 DataCategories_CategoryName {Categories.CategoryName} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 12.8,0,6.2,0.8 Arial,8 0,0,0,0 DataCategories_Description {Categories.Description} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Categories Data2 Top;Black;1;Solid;False;4;Black Transparent 0,3.6,19,0.8 Transparent 0,0,6.4,0.8 Arial,10,Bold 0,0,0,0 FooterCategories_CategoryID {Sum(Data2,Categories.CategoryID)} Black Expression Center FooterCategories 9d010a64f94540ce9ad318500f3f4821 1,1,1,1 Page2 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,0.8 Transparent 0,0,4.6,0.8 Arial,10,Bold 0,0,0,0 HeaderProducts_ProductID ProductID Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent 4.6,0,14.4,0.8 Arial,10,Bold 0,0,0,0 HeaderProducts_ProductName ProductName Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center HeaderProducts Transparent 0,2,19,0.3 Transparent True 0,0,4.6,0.3 Arial,7 0,0,0,0 DataProducts_ProductID {Products.ProductID} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 4.6,0,14.4,0.3 Arial,7 0,0,0,0 DataProducts_ProductName {Products.ProductName} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Products Data3 Top;Black;1;Solid;False;4;Black Transparent 0,3.1,19,0.8 Transparent 0,0,19,0.8 Arial,10,Bold 0,0,0,0 FooterProducts_ProductID {Sum(Data3,Products.ProductID)} Black Expression Center FooterProducts 2a5a338c62904738b9b0e068d7896ca6 1,1,1,1 Page3 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,9.6 All;Black;1;Solid;False;4;Black Transparent 0,2,11.4,0.8 Arial,14 0,0,0,0 Text2 Sum1 = {Sum(Data1,Employees.EmployeeID)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 0,2.8,11.4,0.8 Arial,14 9a19f1c8d1bf4fe5b6534b267a036fd7 0,0,0,0 Text3 Sum2 = {Sum(Data2,Categories.CategoryID)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 0,3.6,11.4,0.8 Arial,14 bf6cfc53eee149b68daf07621f9eebf3 0,0,0,0 Text4 Sum3 = {Sum(Data3,Products.ProductID)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent True 0,5.8,19,1.4 Arial,14 7520b115ffec4a2da8adaf7fcadac9f0 0,0,0,0 Text5 Sum1 + Sum2 + Sum3 = {Sum(Data1,Employees.EmployeeID) + Sum(Data2,Categories.CategoryID) + Sum(Data3,Products.ProductID)} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;Black;1;Solid;False;4;Black Transparent True 0,7.2,19,1.4 Arial,14 0bc8f881ee144d80af50d2b4d990f2b6 0,0,0,0 Text8 Totals.Sum1 + Totals.Sum2 + Totals.Sum3 = {Totals.Sum(Data1,Employees.EmployeeID) + Totals.Sum(Data2,Categories.CategoryID) + Totals.Sum(Data3,Products.ProductID)} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center None;Black;1;Solid;False;4;Black Transparent 0,0,19,1.4 Arial,14,Bold 4a04167b3e4440278ff0311debdfc1cb Center 0,0,0,0 Text9 Calculation at the end of the report Black Expression Center 1 DataBand1 00bf6abfee744f14ab0990932daa6ac7 1,1,1,1 Page4 29.7 21 Arial,100 [50:0:0:0] 268430847 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/3/2014 10:10:55 AM 9/3/2014 9:44:05 AM 7374afa6faac4937833383a751df61c7 Report Centimeters 2014.2.1919 CSharp