{$Page}

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

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

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 ()) )

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

More Examples:

SELECT OrderNumber FROM TransHeader WHERE ID =

SELECT ItemName AS PartNameFROM Part WHERE ItemName LIKE '%'

SELECT * FROM Payment WHERE PaymentDate =