Why does the report display multiple pages when using the Auto Filter feature if the results are included only in the first page?
Analytics, Report Filters
Oracle Service Cloud
The Auto Filter feature provides easy access to filtering on any field included in a report. When this feature is enabled, a down arrow appears in the specified column headings of a generated report. By clicking the down arrow, you can filter the report by a value in that column.
Auto Filtering hides filtered records but does not remove them from the report output. For this reason, total record counts displayed on the report will not change when auto filtering is used.
For example, your report returned 1730 records. The pagination is configured to display only 1000 rows per page. Meaning, results will be displayed in two pages. If you are filtering the results by a value in a particular column, the report will show only those records that have that specific value. Let's suppose that after filtering the data the report is displaying only 19 records. In this case, it is expected the second page to be blank because this feature hides the filtered records and does not remove them from the output.
For additional information, refer to the Enable Auto Filters section in online documentation for the version your site is currently running. To access Oracle Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.