Limit amount of data displayed in report

I've been asked to created a dashboard that shows the top three items on a
list when the query actually results in more than 3 items ....how do I limit
result to just 3 items?
--
Samyra

I'd modify the query to use the Top clause. Then the query will only return
the top 3 (or top whatever).

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Samyra" wrote in message
news:73149C71-A830-419D-BAD3-21AA0FC3BAD1@microsoft.com...
> I've been asked to created a dashboard that shows the top three items on a
> list when the query actually results in more than 3 items ....how do I
> limit
> result to just 3 items?
> --
> Samyra