Thursday, February 25, 2010

Reporting Service 2005 - top values? - limit the number of displayed data rows

Sometimes I need to show only top 5 values from defined data source in the data table, without setting the number of rows in SQL query (top statement).

In data table set visibility expresion for a table row to:

=iif(RunningValue(Fields!Id.Value, CountDistinct, nothing) > 5, true, false)

No comments:

Post a Comment