Find Top 20 2

[NewToThis2]

CV9 - I have a wage report that I need to show only the top 20 highest total wages for the year. A parameter will ask the user to enter the year they want to report on.
The report is grouped by employee. There is a 2nd group that has the sum of all the employee's wages for the year.

I would appreciate anyone's advice on how to write the formula. Thanks!

 

[hilfy]

Have you looked at using the "TopN" report type? That should get you what you need.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[synapsevampire]

In recent versions of Crystal you have the Report->Group/Sort expert.

Note that a choice within is Top N.

Set it to 20, and use the sum of wages

Not sure what your second grouping is, you stated what's in there, but not what it is.

You should only need the Employee group as the report is already filtered for just the obne year.

-k

 

[NewToThis2]

Thanks to you both!