I want be able to show only the 1st 5 rows of a report. I've tried the Top N operator, but when there is a tie for the 'Nth' value, then there can be greater than 5 rows. I want only the 1st 5 rows regardless of a tie.
Note: I'm using parameters in the report, so putting ROWCOUNT in the DataSet Query is not an option because it depends on which parameters are selected.
View Complete Post