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 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 4f6e04db691c44c88e52c92c056c370e 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 d6246395f29f442fa429452448be4e3f 0,0,0,0 Text23 Sub-Reports with Parameters [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 1270b151acc34bc69eeb7096693c0404 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 a67fef61e19145f5b00f3dee33e07117 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 c2393a76c7814baca5b4774ee8d49a53 ReportTitleBand2 Transparent 0,3.2,9.5,4.2 Transparent 0,2,9,1.4 SubReport1 592f3c6db45b424f84610c3d0a239d73 Transparent 0,0,9.4,1.8 SubReport2 ec67529c47c44ea3a3b69515e13421df 0,0,0,0 StartPointPrimitive1 11c2f1038f254b35a49f7dd3e41dc8b4 9.4,1.8,0,0 EndPointPrimitive1 11c2f1038f254b35a49f7dd3e41dc8b4 Categories False True DataBand1 True ASC CategoryName 0,3.2,9.4,1.8 193, 152, 89 Data1 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 TEST Transparent 0,0.4,9.4,0.8 Transparent 0,0,2,0.6 Arial,10 0,0,0,0 Text9 CategoryID Black Transparent 2,0,2.4,0.6 Arial,10 0,0,0,0 Text11 ProductID Black Transparent 4.4,0,5,0.6 Arial,10 0,0,0,0 Text13 ProductName Black HeaderBand2 Transparent 0,2,9.4,0.8 Transparent 0,0,2,0.6 Arial,10 0,0,0,0 Text5 {Products.CategoryID} Black Transparent 2,0,2.4,0.6 Arial,10 0,0,0,0 Text10 {Products.ProductID} Black Transparent 4.4,0,5,0.6 Arial,10 0,0,0,0 Text12 {Products.ProductName} Black Products DataBand3 Transparent 0,3.6,9.4,0 FooterBand2 ec67529c47c44ea3a3b69515e13421df 1,1,1,1 subReport_2 Landscape 29.7 11.4 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent {Categories.CategoryName} Transparent 0,0.4,9,1.8 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,3,1 Header3 Arial,9,Bold ae47474ec98245c78777c7c3f49c5787 Center 0,0,0,0 Text4 Category [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 5.4,1.2,3.6,0.6 Header3 Arial,9,Bold 0723aa419479471a8f4a0888bbf73782 Center 0,0,0,0 Text1 Sales [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,1.2,5.4,0.6 Header3 Arial,9,Bold 3950fad786a6411fb61ff12800a151ed Center 0,0,0,0 Text8 Product [193:152:89] Expression Center All;[193:152:89];1;Solid;False;4;Black Transparent 3,0,6,1 Data1 Arial,9 36bebb3945ad4f81a2e150a7f3fe56bf Center 0,0,0,0 Text6 {Categories.CategoryName} [102:77:38] Expression Center HeaderBand1 None;[193:152:89];1;Solid;False;4;Black Transparent 0,3,9,0.6 Left, Right;[193:152:89];1;Solid;False;4;Black Transparent 5.4,0,3.6,0.6 Data1 Arial,9 89cf9e8a06db4380b59eaa24c5f70eb5 Right 0,0,0,0 Text2 {Sales_by_Category.ProductSales} [102:77:38] Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent 0,0,5.4,0.6 Data1 Arial,9 c7f8fcc0ef0c442396e6156e570f0629 0,0,0,0 Text3 {Line}.{Sales_by_Category.ProductName} [102:77:38] Center Data1 Sales_by_Category Data2 2afe21a6736d4750a55b80343f09176a True DataBand2 ASC ProductName Top;[193:152:89];1;Solid;False;4;Black Transparent 0,4.4,9,0.8 All;[193:152:89];1;Solid;False;4;Black Transparent 0,0,5.4,0.6 Footer1 Arial,9 b1872a65828a41d78ab657b5275f01a2 Right 0,0,0,0 Text14 Total sales: [102:77:38] Center All;[193:152:89];1;Solid;False;4;Black Transparent 5.4,0,3.6,0.6 Footer1 Arial,9 7a6013ebe68c47859fcccc37c481d1e1 Center 0,0,0,0 Text7 {SumD(Sales_by_Category.ProductSales)} [102:77:38] Expression Center Footer1 6e544bff6b134fdd92c5acba8a054a02 FooterBand1 592f3c6db45b424f84610c3d0a239d73 1,1,1,1 subReport_1 Landscape 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 2/25/2016 8:45:37 AM 6/1/2006 11:13:09 AM This sample demonstrates how to use a Sub-Report component with parameters in a Master-Detail report. C:\Program Files\Stimulsoft Reports.Ultimate 2013.3\Bin\Reports\SQLSubReportWithParameters.mrt a7f6f78b64c44a7991274e9330cb3f1e Report Centimeters 2013.3.1800 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 242, 234, 221 CrossTab