====== {$Page} ======

A is displayed using the following tabs or pages … to show the order information grouped appropriately.


===== Using Parameters in the Query =====



Parameters are dynamically created from the SQL statement using special syntax. To use a parameter, surround the name you wish to use with ****.

**Parameter Options**

**Range Values**: To create a parameter that uses a value range, append START and END to the end of the parameter name.

**//Example://**



SELECT CompanyName FROM Account WHERE DateCreated BETWEEN **** AND ****{{::sqlreport_daterangeoption.jpg?nolink&|}}



On the Options Tab, there will be a DATE parameter option with a range selection.

**Set / Multiple Values**: To create a parameter that takes multiple values, append SET to the end of the parameter name.

**//Example://**



SELECT ItemName As ProductName FROM CustomerGoodsItem WHERE ****( (-1**** IN ****()) OR (****ID IN **()) )**



{{::sqlreport_productsetoption.jpg?nolink&|}}



On the Options Tab, there will be a Products parameter option with mulitple input screen.



//**More Examples:**//



SELECT OrderNumber FROM TransHeader WHERE ID = ****



{{::sqlreport_orderexploreroption.jpg?nolink&|}}



SELECT ItemName AS PartNameFROM Part WHERE ItemName LIKE '****%'



{{::sqlreport_stringoption.jpg?nolink&|}}



SELECT * FROM Payment WHERE PaymentDate = ****{{::sqlreport_datetimeoption.jpg?nolink&|}}