Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Enough research will support any theory
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!!!!


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?"


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


Name *

Email Address *

Comment *

To prove you are human what is:

81 + 76 =