Opposite of TopN -- sql server reporting services

montgoss NO[at]SPAM hotmail.com
8/20/2004 1:47:59 PM

Is there a way to get "the rest" of a list? I have a TopN filter
working on one table showing the top 3 results. Now, I have another
table that I want to show everything but the top 3. This table will be
hidden by default, but that shouldn't matter. Is there a way to get
"not TopN =3"?

Also, how would I get the first 3, instead of top 3? My results would
be pre-sorted coming from the datasource and I just want to show the
first few rows.

Dave
8/21/2004 11:49:03 AM

Are you using a stored procedure? You could use a correlated subquery. For
example: select bookid from books where bookid not in (select top 3 bookid
from books).

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Opposite of TopN