Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Baxter
Starting Member
2 Posts |
 Posted - 2012-03-07 : 06:10:40
|
| Hi,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.Thanks,Paul |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-03-07 : 07:03:48
|
| 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.... |
 |
|
|
Baxter
Starting Member
2 Posts |
Posted - 2012-03-07 : 09:30:29
|
| Thanks the issue is that I have two grouped X and Y, and the rownumber falls over |
|
|
|
|
|
|
Reporting Services Excluding Multiple records