Rowfilter TOP 10

  • Thread starter Thread starter Hannes [MVP]
  • Start date Start date
There's no TOP-like syntax in RowFilter. However, you could
still achieve this functionality. Say you have customer
information and you're sorting on Country, then CustomerID (for
uniqueness). To display just the first 10 rows, locate the last
row to display and use its values for Country and CustomerID to
construct a filter like:

Country < {Last_Country} OR
(Country = {Last_Country} AND CustomerID <= {Last_CustomerID})

You can use similar logic to display rows 11 through 20.

I hope this information proves helpful.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2003 Microsoft Corporation. All rights reserved.
 
Back
Top