posted 9/23/2010 by timmurphy - Views: [9922]
Here is a way to display the Top or Bottom 10 records of an Interactive Sort. The Interactive Sorting is the easy part. First, in the Text Box Properties, Enable interactive sorting and choose what you want to sort by.
Then to only show the Top or Bottom 10 records right click on the Row Tab to the left of the Table and select Row Visibilty…
Click the Expression button and enter the following RowNumber expression:
The rows greater than 10 will be hidden in this case. When you preview and click the Interactive Sort arrows you will see either the Top or Bottom 10 items depending or your sort order.
Here is the expression again if you want to copy and paste it for your use:
=RowNumber(Nothing) > 10
Expressions are powerful things!
World's most powerful computer: 1 million billion calculations per second
This is a good tip. Thanks for posting this.
Great post Tim! I know that many people can use this to help consolidate stored procedures, as well as reports.
Nice little tip! I've used Filters at the dataset level quite a bit, but this is a quick and easy way to implement.