Using Top N with Cross-Tabs Reports

Group sorts can be done on a report level so that the records are sorted and removed as necessary. However, there are times when the records are needed in the overall report but not in a cross-tab.

  1. Right-click in the top-left corner of the cross-tab where there is no data or words and choose Group Sort Expert. Choose Top N for the primary list box and change 5 to 10 in the Where N Is field. In this example, make sure that the Others option is not selected.
     
  2. Click OK in the Group Sort Expert to view the final result, as shown in Figure 10.5.
     

    Figure 10.5. Cross-tab with a Group Sort applied.

    graphics/10fig05.jpg  
  3. Save your work by choosing File, Save As. Call this cross-tab2.rpt and then click OK.
     




Special Edition Using Crystal Reports 10
Special Edition Using Crystal Reports 10
ISBN: 0789731134
EAN: 2147483647
Year: 2003
Pages: 341
Simiral book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net