Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Each problem that I solved became a rule which served afterwards to solve other problems
 
Descartes
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

21
May

How Do I Create a TopN Cross Tab Report in Crystal Reports XI?

During a number of recent Crystal Reports XI training sessions, I have been repeatedly asked "How Do I Create a TopN Cross Tab Report?"

Solution

Creating a TopN Cross Tab report, is relatively easy to do, if not that obvious.
  1. Select the cross tab report object

  2. From the Report menu, select the Group Sort Expert option

  3. In the Cross-Tab TopN and Sort Expert dialog box, select the required group of the cross-tab

  4. From the For This Group Sort drop down, select the TopN option

  5. Enter the required value in the Where N is, text box

  6. Select the required report summary field from the Based on drop down




If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

21 + 57 =