When running a Report Gateway report, you can specify what data you want to include in the Parameters section. You can choose to include all data, only data that you specify to include, or all data except what you specify to exclude.
▪ To include data for all available items, select a Filter Type of All.
Note
If you select this option, the Select by field will be disabled.
▪ To include data for only items associated with the values you specify, follow these steps:
a. Select a Filter Type of Include.
b. In the Filter By field, select the criteria to limit the data available.
c. In the Selection field, select the values to include. To clear all of the selected data, click the X icon in the top right corner of the Selection field.
▪ To include data for all data except for the items you specify, follow these steps:
a. Select a Filter Type of Exclude.
b. In the Filter By field, select the criteria to limit the data available.
c. In the Selection field, select the values to exclude. To clear all of the selected data, click the X icon in the top right corner of the Selection field.
After selecting your Filter Type, complete any remaining parameter fields to further specify the data you want to include in the report.
If the report you have opened is an SSRS report that uses at least one secondary data source, the Secondary data sources section appears below the Parameters section. In this section, a field appears for each secondary data source platform you have configured. For each configured platform, you can choose the secondary data source to use when running the report. If there is only one available secondary data source, the field is read-only.