Is there any way I can find the rank of a set of values in Microsoft Reports?
For instance, in order to produce a table like the one below, what function/formula do I enter in the Rank column?
+------+-----+ |Value | Rank| +------+-----+ | 12 | 3 | | 30 | 5 | | 5 | 1 | | 10 | 2 | | 24 | 4 | 开发者_开发百科+------+-----+
Update
Values in the value column are produced from calculations on the report-side so I cannot find the rank using a query.The closest you are going to get is the RowNumber function, but that depends on the underlying sort order.
I thoroughly recommend moving the value column logic server side and creating using SQL to get a rank value there.
精彩评论