The Where button is used to add filters to the data. You can hard code values or add parameters to filter the data when downloading.
Field | Description |
---|---|
Search Columns | Use this to filter the list of Available Columns. |
Available Columns | This lists all columns that can be filtered based on the main table and joined tables selected. |
Selected Column | This is the column that will be filtered. |
Value 1 | This can be a hard coded value or you can use the @PARAM button to create a parameter. |
Value 2 | This appears when you use the Between and Not Between operators. |
And | Use this if the filter should be true in addition to what already exists. |
Or | Use this if the filter could be true or what already exists is true. This is not used a lot. |
Allow Blank Parameter Values | Use this when adding a parameter if you do not want the parameter to be required. |
New Parameter | Enter a new parameter name here and make sure to select a column. This is only needed if the parameter is only used on the Select or Join buttons. |
Parameters | This lists all parameters currently in the report. |
Where Clause | This shows the current filters. You can add manual changes to the box if needed. |
Button | Description |
---|---|
This will clear the search box. | |
Equal To | |
Not Equal To | |
Greater Than or Equal To | |
Greater Than | |
Less Than | |
Less Than or Equal To | |
This adds a parameter to the Value fields and cycles through existing parameters. | |
Use to search for a specific pattern. If a match is found then the record will be included. | |
Use to search for a specific pattern. If a match is found then the record will not be included. | |
Allows you to specify multiple values that you separate with a comma. | |
Allows you to specify multiple values that you separate with a comma. | |
Use for values within a given range. | |
Use for values not within a given range. | |
Use to find fields with no value. | |
Use to find fields with a value. | |
(Parameter) | This will add the new parameter if a column is selected and a parameter named is entered. |
(Parameter) | This will show in place of Add if you select a parameter from Parameters to edit. Use this to save any changes. |
(Parameter) | This will clear the Selected Column and New Parameter fields. |
(Parameter) | This will delete any selected parameters. If you delete parameters make sure the appropriate lines in the Where Clause are removed. |
(Column) | This will add the new filter after all required values have been selected. |
(Column) | This will clear all fields on the form. |
This will save any changes to the Where portion of the SQL Statement. | |
This will cancel any changes to the Where portion of the SQL Statement. |
Post your comment on this topic.