Static Filter vs. Tabular Report Filter
A static filter has several advantages over the filter that can be applied to a tabular report.
Filter in a Tabular Report: The tabular report filter (right-click and filter within a rendered tabular report) is a client-side filter that filters the data after it has been retrieved from the database.
Static Filter in a Dynamic Template: A static filter is a server-side filter that extracts only the filtered subset of data from the database. The static filter is useful when doing totals because the counts will reflect the sum of only the filtered data returned from the database. Also, static filters are recommended for reports where there is so much data that pagination is required when the report is rendered.