Ranking

[mcrisf]

Is it possible in CrystalRep 10 to rank a group (example i have salesreps and their sales amount ..i want to rank the salesreps depending on their MTD sales and rank on their YTD sales)...?
thx

 

[thisisboni]

just do a 'sort by' upon the field you want to -
CR10 has a sort by option

/Sam

 

[mcrisf]

yes, but i would like to show the rank to the user...

 

[thisisboni]

I would try by throwing in a variable which increments itself where the group by or sort by is done.

This this variable is the rank -

 

[mcrisf]

i tried it...but i think it doesn't work....do u have some code to post?

 

[lbass]

If you only have one group, you can add the special field "groupnumber" to the group section after doing the topN/group sort. If you report is more complex, you need to specify your groups.

-LB

 

[mcrisf]

I have only one group..I orderde it by ID and then by MTD, i used the grouonumber function....but it gave me wrong numbers...for example i have only 2 records and the formula (where is the groupnumber) gives me 95 and 105..!!!!!

 

[thisisboni]

use 'RecordNumber' and display that in the group header section

/Sam

 

[lbass]

What you are saying doesn't make sense. There is no formula for group number. Just go to the field explorer->special fields->groupnumber. Drag that into the group section you are displaying.

-LB