all groups > sql server reporting services > january 2007 >
You're in the

sql server reporting services

group:

Top N + The Rest = TOTAL


Top N + The Rest = TOTAL jordi_ramis NO[at]SPAM hotmail.com
1/5/2007 8:09:32 AM
sql server reporting services:
Hi,

I want to make something like this:


TOP 3 Sellers!
Seller Profits
-----------------------------
Maggie 130
John 70
Mike 30
*THE REST* 200
-------------------------------
TOTAL 430

Showing the TOP 3 Sellers it's easy using the TOP N filter, the
problem comes when I have to show THE REST of sellers (the ones not
included in the top 3) grouped in a row.

My dataset it's linked to a Stored Procedure, I have not rights to
modify this Stored Procedure so I have to do this only using the
Reporting Services capabilities.

Anyone knows how can this be done?. Thanks a lot.
RE: Top N + The Rest = TOTAL Ashok
3/7/2007 3:33:05 PM
I have the same issue. Jordi, Did you able to solve this?

Thank you - Ashok

[quoted text, click to view]
AddThis Social Bookmark Button