Rank 1

[tsusnik]

I hope rank is the correct English word for the thing I'm looking for. I think that some data will describe the problem.

Group Number Name Count({Field}) Rank

1 Person1 79 1
2 Person2 74 2
3 Person3 74 2
4 Person4 56 4
5 Person5 56 4
6 Person6 42 6

I can't create a formula for the column 'Rank'. The data is sorted with Top N/Sort Group Expert. I can't use the Previous function because of the count field. Is there any way to solve this problem?

Thanks for any advice, Tomaz

 

[kenhamady]

Put this in the Group Footer:

WhilePrintingRecords;
NumberVar PassCount := count(x,y)


Put this in the Group Header:
WhilePrintingRecords;
NumberVar PassCount;
NumberVar Rank;

if Passcount = count(x,y)
then Rank:= Rank
else Rank := Rank+1 Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/