Forum Discussion
Filtered Subtotal with Paginated Reports
Hello,
I have a paginated report that has a filter on the body of the report. The columns consist of MTD and YTD totals. All numbers are correct with the exception of the MTD total. The total is totalling all of the results possible, not just the filtered results. Is there anyone that knows how to have the total show what's actually in the column (the filtered date), not the whole data set?
TIA!
1 Reply
Jon-HeideMicrosoft Employee
Yes, it's possible, it's a matter at what scope the filter is applied. Filters can be applied at the dataset, table or group levels. The month to date probably needs an additional date filter applied to it.
For more info on data scopes, see: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/expression-scope-for-totals-aggregates-and-built-in-collections?view=sql-server-ver16