I have recently been asked to change a report on reporting services that contains data totals. The report is a stored proc that generates totals and the dataset to be viewed. The request is to have another total row which excludes the top 3 records. The proc is order by desending records so the top 3 records will always be in the same rows in reporting services. Is their an easy way to exclude these rather than changing my back ground code.
One thought that comes to mind is to use the RowNumber function in SSRS. You would use the same SUM expression, but instead of just using a field value, you would change it to an expression that equal to the field value if RowNumber is > 3.
I have not experimented with the RowNumber function, so....
Reporting Services Excluding Multiple records
Posted - 03/07/2012 : 06:10:40
