开发者

Find Rank in Microsoft Report

开发者 https://www.devze.com 2023-02-03 15:32 出处:网络
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?

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消