Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String 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 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 Employee_Sales_by_Country Country,System.String LastName,System.String FirstName,System.String ShippedDate,System.DateTime OrderID,System.Int32 SaleAmount,System.Decimal 30 False Employee_Sales_by_Country NorthWind _x0040_DateBeginning,DateTimePickerControl1.Value,7,10 _x0040_DateEnding,DateTimePickerControl2.Value,7,10 SELECT DISTINCTROW Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate, Orders.OrderID, [Order Subtotals].Subtotal AS SaleAmount FROM Employees INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID) ON Employees.EmployeeID = Orders.EmployeeID WHERE Orders.ShippedDate BETWEEN @DateBeginning AND @DateEnding 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 Categories CategoryID Categories CategoriesProducts CategoryID Suppliers SupplierID Suppliers SuppliersProducts SupplierID ,LastEmployeeName,LastEmployeeName,System.String,,False,False ,LastCountryName,LastCountryName,System.String,,False,False EngineV2 Control Control 8,8,88,16 Microsoft Sans Serif,8 Black 8, 8 LabelControl1 88, 16 Beginning Date Control 8,40,64,16 Microsoft Sans Serif,8 Black 8, 40 LabelControl2 64, 16 Ending Date Window 104,8,128,20 Microsoft Sans Serif,8 Black 104, 8 1/1/1997 12:00:00 AM 1/1/1994 12:00:00 AM DateTimePickerControl1 128, 20 False 8/16/1994 12:00:00 AM Window 104,40,128,20 Microsoft Sans Serif,8 Black 104, 40 1/1/1997 12:00:00 AM 1/1/1994 12:00:00 AM DateTimePickerControl2 128, 20 False 6/5/1996 12:00:00 AM Employee_Sales_by_Country.Connect(); 40,80,96,24 True OK Microsoft Sans Serif,8 Black 40, 80 ButtonControl1 96, 24 Ok True 144,80,96,24 Cancel Microsoft Sans Serif,8 Black 144, 80 ButtonControl2 96, 24 Cancel Microsoft Sans Serif,8 e461cde548f944468625b9b5ff68e63c 0, 0 Form1 256, 136 Select range of dates from 1994 to 1996 None;Black;2;Solid;False;4;Black Transparent 1 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 7b30c486094f4e16a0af90aadb422246 Right 0,0,0,0 Text17 {PageNofM} [102:77:38] Center d4ff34a206724e3fbbe889d815549517 PageFooterBand1 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 58d1e833e69f4f3f81ae1660b6365ac7 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 ff7ac5c25d7c4b81b5c5836e209d7991 0,0,0,0 Text23 Parameters from Dialog Form [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 a23a16ed1a934758b4ee987a8ec7ecf0 0,0,0,0 Text5 {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 4398073840bb4f65b9a65eaf8e86d941 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 3f26490529ff436b930bf559bb2ba029 ReportTitleBand1 Transparent 0,3.2,19,1.6 None;[193:152:89];1;Solid;False;4;Black Transparent 0,0,19,1.6 Title1 Arial,19 01802cb83a714cd7ad0b76fee9838d83 Center 0,0,0,0 Text15 Employee sales by country from {DateTimePickerControl1.Value.ToString("MM.dd.yyyy")} to {DateTimePickerControl2.Value.ToString("MM.dd.yyyy")} [193:152:89] Expression Center HeaderBand1 False Transparent 0,5.6,19,1 All;[193:152:89];1;Solid;False;4;Black Transparent 0,0.4,19,0.6 Header2 Arial,12,Bold Center 0,0,0,0 Text1 {Employee_Sales_by_Country.Country} [193:152:89] Center {Employee_Sales_by_Country.Country} GroupHeaderBand1 Transparent 0,7.4,19,0.6 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,19,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text4 {Employee_Sales_by_Country.FirstName} {Employee_Sales_by_Country.LastName} [193:152:89] Center {Employee_Sales_by_Country.LastName} GroupHeaderBand2 True LastEmployeeName = Employee_Sales_by_Country.FirstName + " " + Employee_Sales_by_Country.LastName; LastCountryName = Employee_Sales_by_Country.Country; Transparent 0,8.8,19,0.6 Left, Right;[193:152:89];1;Solid;False;4;Black Transparent 0,0,6.8,0.6 Data1 Arial,9 0,0,0,0 Text2 {Employee_Sales_by_Country.OrderID} [102:77:38] No Date Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent 6.8,0,5.2,0.6 Data1 Arial,9 Center 0,0,0,0 Text3 {Employee_Sales_by_Country.ShippedDate} [102:77:38] Center Left, Right;[193:152:89];1;Solid;False;4;Black Transparent 12,0,7,0.6 Data1 Arial,9 Right 0,0,0,0 Text9 {Employee_Sales_by_Country.SaleAmount} [102:77:38] , 0 0 Center Employee_Sales_by_Country Data2 DataBand1 ASC Country ASC LastName ASC FirstName ASC ShippedDate Top;[193:152:89];1;Solid;False;4;Black Transparent 0,10.2,19,0.2 Footer1 FooterBand1 True Transparent 0,11.2,19,0.8 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 14.2,0,4.8,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text13 {SumD(Employee_Sales_by_Country.SaleAmount)} [193:152:89] , 0 0 Center All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,14.2,0.6 Header3 Arial,9,Bold Center 0,0,0,0 Text14 Total by {LastEmployeeName}: [193:152:89] Center GroupFooterBand2 Transparent 0,12.8,19,0.8 All;[193:152:89];1;Solid;False;4;Black Transparent 14.2,0,4.8,0.6 Footer1 Arial,9 Center 0,0,0,0 Text6 {SumD(Employee_Sales_by_Country.SaleAmount)} [102:77:38] , 0 0 Center All;[193:152:89];1;Solid;False;4;Black Transparent 0,0,14.2,0.6 Footer1 Arial,9 Center 0,0,0,0 Text7 Total by {LastCountryName}: [102:77:38] Center GroupFooterBand1 Transparent 0,14.4,19,1.2 All;[193:152:89];1;Solid;False;4;Black Transparent 14.2,0,4.8,1.2 Footer1 Arial,9 Right 0,0,0,0 Text11 {SumD(Employee_Sales_by_Country.SaleAmount)} [102:77:38] , 0 0 Center All;[193:152:89];1;Solid;False;4;Black Transparent 0,0,14.2,1.2 Footer1 Arial,9 Right 0,0,0,0 Text12 Total by all employees: [102:77:38] Center ReportSummaryBand1 bbdd06f4012e439fbed8a081530472a3 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 Parameters from Dialog Form 6/17/2011 1:27:11 PM 6/1/2006 11:13:09 AM This sample demonstrates how to use parameters. E:\__Version\2011.1\Stimulsoft Reports.Net 2011.1 Trial\Bin\Reports\SQLParameters.mrt 8d18fe1c6fd64c19a8aa9136e194609a Report Centimeters 2011.1.1000 CSharp False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Right Title1 None [193:152:89] Center False None;[102:77:38];1;Solid;False;4;Black Transparent Arial,9 Title2 None [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Header1 None [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Center Header2 None [193:152:89] Center False True True All;[193:152:89];1;Solid;False;4;Black [242:234:221] Arial,9,Bold Center Header3 None [193:152:89] Center False All;[193:152:89];1;Solid;False;4;Black Transparent Arial,9,Bold Center Header4 None [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Data1 None [102:77:38] Center False False False False False [240:237:232] Arial,9 Data2 None Black False None;[193:152:89];1;Solid;False;4;Black [240:237:232] Arial,9 Data3 None [102:77:38] Center False Top;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Footer1 None [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Right Footer2 None [193:152:89] Center 242, 234, 221 CrossTab