Crystal Top Ten ranking

building reports crystal reports
1

I am creating a report in which the required dimension is passed as parameter.
For dimension passed (Ex: all project worked by company X) there are four measure (A,B,C,D) that will be filled in the report. I need to implement dynamic top ten ranking for the dimension based on the sum of the four measures (A+B+C+D).

What are the methods to implement top ten ranking using stored data option in Crystal 2008?

Indra.bobj (BOB member since 2009-06-18)

2

I have two methods in the past for rankings:

  • Return only the top X records in the data provider (command object). You write your normal query as a sub-query with an order by statement and the outer query has a RowNum <= X as part of the condition.

  • Order the data and the conditionally supress all detail records after X.

BDeLong (BOB member since 2008-01-15)

3

You can also use the group sorting feature. The only irritating thing is that you have to put the field in a group and put a summary function on it in order to use it.

edurda :us: (BOB member since 2005-09-08)