Solved

Counting Highest/ Lowest Represented Nationalities

Posted on 2006-11-08
4
236 Views
Last Modified: 2010-05-18
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
Comment
Question by:Faraj1969
  • 2
  • 2
4 Comments
 
LVL 17

Accepted Solution

by:
MIKE earned 125 total points
Comment Utility
Use TOP N expert...and setup your summary based on your needs...let me know if you need more info..

MikeV
0
 

Author Comment

by:Faraj1969
Comment Utility
I'll check it out and get back to ya.

Cheers mate...
0
 

Author Comment

by:Faraj1969
Comment Utility
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
 
LVL 17

Expert Comment

by:MIKE
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now