to […] to search for any value. When combined with the Parameter setting (below), this allows the end-user to select the parameters rather than setting a pre-determined value to be used. NOTE: To combine multiple filters, the filters should be configured first, and combined using the Logic’ entry box (see below). ‘Filter Blank select this box to return results with the value of blank (null). – Parameter selecting this checkbox causes the filter configuration to be displayed on the report results – page. The user running the report can change the filter and click the Results’ button on the ‘Update toolbar to see the results with the new filter. NOTE: When filters are applied to a report, they do not display at the top of the page. They ‘Preview’ will only appear at the top of the Report results when the report is run, not previewed. Icons The standard delete , add field above , add field below , and move icons are displayed. – Show Filters in Report Description selecting this checkbox displays the values of each filter used to – generate the report in the report’s descriptive text, but does not allow the user to change the filters. To allow the user to change the filters, select the checkbox next to each filter you want the user to ‘Parameter’ be able to change. Require drop-down box making a choice in this drop-down box requires the end user to select a value for – at least one, the first, or the first two filters when running the report. NOTE: To cause a filter to appear to the end user, the checkbox must be selected for the filter. ‘Parameter’ Filter Logic to combine the filters in any way other than simple logic, the report designer must – ‘AND’ type the filter logic into the box. For example, to combine three filters so that a result must match both filter one and two OR match filter three to appear in the results, the report designer would type: (1 AND 2) OR 3 (using the filter numbers). Parentheses and OR can also be used, as shown in the example above. NOTE: This field displays an by default; this is an Example of how the field can be used. Filters ‘Ex:’ with the will be ignored. ‘Ex:’ The following button displays: Preview clicking this button generates a preview of the report results page, without saving the report. The – report designer can alternatively click the tab instead of using this button ‘Preview’
to […] to search for any value. When combined with the Parameter setting (below), this allows the end-user to select the parameters rather than setting a pre-determined value to be used. NOTE: To combine multiple filters, the filters should be configured first, and combined using the ‘Filter Logic’ entry box (see below). Blank – select this box to return results with the value of blank (null). Parameter – selecting this checkbox causes the filter configuration to be displayed on the report results page. The user running the report can change the filter and click the ‘Update Results’ button on the toolbar to see the results with the new filter. NOTE: When filters are applied to a report, they do not display at the top of the ‘Preview’ page. They will only appear at the top of the Report results when the report is run, not previewed. Icons – The standard delete , add field above , add field below , and move icons are displayed. Show Filters in Report Description – selecting this checkbox displays the values of each filter used to generate the report in the report’s descriptive text, but does not allow the user to change the filters. To allow the user to change the filters, select the ‘Parameter’ checkbox next to each filter you want the user to be able to change. Require drop-down box – making a choice in this drop-down box requires the end user to select a value for at least one, the first, or the first two filters when running the report. NOTE: To cause a filter to appear to the end user, the ‘Parameter’ checkbox must be selected for the filter. Filter Logic – to combine the filters in any way other than simple ‘AND’ logic, the report designer must type the filter logic into the box. For example, to combine three filters so that a result must match both filter one and two OR match filter three to appear in the results, the report designer would type: (1 AND 2) OR 3 (using the filter numbers). Parentheses and OR can also be used, as shown in the example above. NOTE: This field displays an ‘Ex:’ by default; this is an Example of how the field can be used. Filters with the ‘Ex:’ will be ignored. The following button displays: Preview – clicking this button generates a preview of the report results page, without saving the report. The report designer can alternatively click the ‘Preview’ tab instead of using this button