• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Counting Highest/ Lowest Represented Nationalities

Hi Experts,

All records have a unique value called Index_No, and ofcourse those records represents staff members with different nationalities.each record have a field called Nationality.

I need to show in my report the Highest 5 represented nationalities, and also lowest 5 represnted nationalities. An example :

United States of America       18 Staff
France                                 16 Staff
Suadi Arabia                         9  Staff

And so on....

Can we do that in Crystal ?

Cheers
0
Faraj1969
Asked:
Faraj1969
  • 2
  • 2
1 Solution
 
MIKESoftware Solutions ConsultantCommented:
Use TOP N expert...and setup your summary based on your needs...let me know if you need more info..

MikeV
0
 
Faraj1969Author Commented:
I'll check it out and get back to ya.

Cheers mate...
0
 
Faraj1969Author Commented:
Hi again,

I tried to read the help about it in CR10 and it confused the hell outta me. Any more info would be greatly appreciated.

Cheers
0
 
MIKESoftware Solutions ConsultantCommented:
Hi Faraj...sorry for the delay..there should be a button in your Crystal Report program that is called GROUP SORT. You should be able to set the TOP N sort there.

Please let me know if you have specific questions.

Thanks
MikeV
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now