====== Setting Report Parameters ======

To pull useful information from your store database, you can use the parameters associated with criteria, in the criteria section of the Reports dialog box. **After** selecting a criteria, you can limit the amount of data displayed by using a parameter, and then entering a value for the parameter. Some of the parameters are described in the table below.

{{:reports:parameter_of_criteria.png|}}

===== Explanation of Parameters =====

Note: For purposes of explaining the following parameters, we will use the commonly used criteria of Account Number in conjunction with the Item Description With Sales Report.

  * **All** : The **All** parameter does not need any values associated with it. Using all will include will yield every result for that criteria. \\ {{:reports:all_parameter.png|}}
  * **Is** : The **Is** parameter is used when looking for one specific result. \\ Example: If I am looking for the sales of inventory for account 1, I would put a value of 1 next to the parameter of **Is**. \\ {{:reports:is_parameter.png|}}
  * **Is Not** : The **Is Not** parameter is used to look for all the data of the selected criteria, except for the value defined in **Is Not**. \\ Example: I want all the data for the sales of inventory except the data for account 12. I will set the value for **Is Not** to 12 to exclude that account number. \\ {{:reports:is_not_parameter.png|}}
  * **After** : The **After** parameter is used to yield results for all data that comes after the set value of **After**. \\ Example: I only want to see the sales for items on accounts 101 and beyond. I will set the parameter value of **After** to 100. \\ {{:reports:after_parameter.png|}}
  * **Before** : The **Before** parameter is used to yield results for all data that comes before the set value of **Before**. \\ Example: I only want to see the sales for items on accounts 1-199. I will set the parameter value of **Before** to 200. \\ {{:reports:before_parameter.png|}}
  * **Between** : The **Between** parameter is used to yield results for all data that falls between the set values of **Between**. \\ Example: If I need to know the sales for all items that sold on accounts between account 50 and 60, I would set the values for 50 and 60 respectively. \\ {{:reports:between_parameter.png|}}}
  * **In** : The **In** parameter is used to yield results for all data defined by the set values of **In**. The **In** parameter can be used for multiple defined values by separating those values using commas. \\ Example: I need to yield results for accounts 13, 20, and 45. I can use the **In** parameter, with commas separating the values, to get the desired results. \\ {{:reports:in_parameter.png|}}
  * **Not In** : The **Not In** parameter is used to yield results for all data **Not** Defined by the set values of **Not In**. The **Not In** parameter can be used for multiple defined values by separating those values using commas.

Example: I need to yield results for accounts outside of 20, 37,and 98. I can use the **Not In** parameter, with commas separating the values, to get the desired results.

{{:reports:not_in_parameter.png|}}

==== How To Print Reports Reports Menu ====
==== Next Article In Section ====

Click the following link to move to the next article in this section: \\ [[:reports:howtoprintreports|How to Print Reports]]

==== Related Topics ====

[[reports:settingreportsparameters]]
[[reports:selectingcorrectreport]]
[[reports:createareport]]
[[reports:criteriaoptionscolor]]
[[reports:batchreports]]
[[reports:exportingreports]]
[[reports:favoritereports]]