Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Picture,System.Byte[] 30 Categories NorthWind select * from categories Sales_by_Category CategoryID,System.Int32 CategoryName,System.String ProductName,System.String ProductSales,System.Decimal 30 Sales_by_Category NorthWind _x0040_MasterCategory,Categories.CategoryID,2,10 True SELECT DISTINCTROW Categories.CategoryID, Categories.CategoryName, Products.ProductName, Sum([Order Details Extended].ExtendedPrice) AS ProductSales FROM Categories INNER JOIN (Products INNER JOIN (Orders INNER JOIN [Order Details Extended] ON Orders.OrderID = [Order Details Extended].OrderID) ON Products.ProductID = [Order Details Extended].ProductID) ON Categories.CategoryID = Products.CategoryID WHERE (((Orders.OrderDate) Between #1/1/1995# And #12/31/1995#)) AND Categories.CategoryID = @MasterCategory GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName ORDER BY Products.ProductName; Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Categories2 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 Categories2 CategoryID Categories2 CategoriesProducts CategoryID Suppliers SupplierID Suppliers SuppliersProducts SupplierID ,LastEmployeeName,LastEmployeeName,System.String,,False,False ,LastCountryName,LastCountryName,System.String,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent 2 9.6 Transparent 0,0.4,9.6,1.8 Transparent 0.2,0.2,9,1.4 SubReport1 592f3c6db45b424f84610c3d0a239d73 0,0,0,0 StartPointPrimitive1 11c2f1038f254b35a49f7dd3e41dc8b4 9.4,1.8,0,0 EndPointPrimitive1 11c2f1038f254b35a49f7dd3e41dc8b4 Categories False True DataBand1 True ASC CategoryName 0,0.4,9.4,1.8 SaddleBrown 11c2f1038f254b35a49f7dd3e41dc8b4 RectanglePrimitive1 fcc843a43d0f4a059750ae3118fa654f 1,1,1,1 Page1 Landscape 14.8 21 A5 True Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,9,2 All;White;1;Solid;False;4;Black Peru 0,0,3,0.8 Arial,14,Bold ae47474ec98245c78777c7c3f49c5787 Center 0,0,0,0 Text4 Category White Expression Center All;White;1;Solid;False;4;Black SandyBrown 5.4,1,3.6,0.8 HeaderStyle Arial,14.25,Bold,Point,False,204 0723aa419479471a8f4a0888bbf73782 Center 0,0,0,0 Text1 Sales White Expression Center All;White;1;Solid;False;4;Black SandyBrown 0,1,5.4,0.8 HeaderStyle Arial,14.25,Bold,Point,False,204 3950fad786a6411fb61ff12800a151ed Center 0,0,0,0 Text8 Product White Expression Center All;White;1;Solid;False;4;Black NavajoWhite 3,0,6,0.8 Arial,14,Bold 36bebb3945ad4f81a2e150a7f3fe56bf Center 0,0,0,0 Text6 {Categories.CategoryName} SaddleBrown Center HeaderBand1 All;White;1;Solid;False;4;Black NavajoWhite 0,3.2,9,0.6 Transparent 5.8,0,3,0.6 _x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_1,Black,Transparent,Arial_x002C_9.75_x002C_Regular_x002C_Point_x002C_False_x002C_204,True,False, Arial,10 89cf9e8a06db4380b59eaa24c5f70eb5 Right 0,0,0,0 Text2 {Sales_by_Category.ProductSales} Black Center Transparent 0,0,5.8,0.6 _x0028_Line_x0020__x0026__x0020_1_x0029__x0020__x003D__x003D__x0020_1,Black,Transparent,Arial_x002C_9.75_x002C_Regular_x002C_Point_x002C_False_x002C_204,True,False, Arial,10 c7f8fcc0ef0c442396e6156e570f0629 0,0,0,0 Text3 {Line}.{Sales_by_Category.ProductName} Black Center Even Sales_by_Category 2afe21a6736d4750a55b80343f09176a True DataBand2 Odd ASC ProductName Transparent 0,4.6,9,1 Transparent 0,0,6.2,0.8 Arial,12,Bold b1872a65828a41d78ab657b5275f01a2 Right 0,0,0,0 Text14 Total sales: SaddleBrown Center All;White;1;Solid;False;4;Black SandyBrown 6.2,0,2.8,0.8 Arial,14,Bold 7a6013ebe68c47859fcccc37c481d1e1 Center 0,0,0,0 Text7 {SumD(Sales_by_Category.ProductSales)} White Expression Center 6e544bff6b134fdd92c5acba8a054a02 FooterBand1 592f3c6db45b424f84610c3d0a239d73 1,1,1,1 subReport_1 29.7 11 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 Sub-Reports with parameters 9/22/2009 9:46:27 AM 6/1/2006 11:13:09 AM D:\Stimulsoft\Stimulsoft.Reports\Demo\Bin\Reports\SQLMasterDetail.mrt 0f455111cf044abe90d089a3629d1d26 Report Centimeters 2009.3.505 CSharp All;White;1;Solid;False;4;Black NavajoWhite Arial,8 Even Black All;White;1;Solid;False;4;Black PapayaWhip Arial,8 Odd Black All;White;1;Solid;False;4;Black SandyBrown Arial,14.25,Bold,Point,False,204 HeaderStyle White