Report Builder TOP1

I am trying to use report builder to generate a report that has multiple transaction. All I need is the most recent. normally I would use a select top1 in SQL but can not find anything in report builder that can accompish the same thing. Any ideas would be greatly appreciatedHat about using a named query in the DSV with the TOP 1 and order by clause in it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de