开发者

Find Rank in Microsoft Report

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜