SAP Knowledge Base Article - Public

1876499 - How to obtain the same sort sequence as appears in the chart in Crystal Reports?

Symptom

A Crystal Report which contains a chart and the data in the chart is in specific order.

Insert a Cross-tab which shows the exact sort sequence as appears in the chart.

Chart.pngCross tab.png

Environment

  • Crystal Report 2008
  • SAP Crystal Report 2011

Reproducing the Issue

  1. Create a report and insert a chart in the report.
  2. Right click on the chart and select Chart Expert -> Data.
  3. Click on the field under On change of, TopN button would appear.
  4. Click on TopN and select Bottom N for displaying data in ascending order in the chart OR Top N for displaying data in descending order in the chart from drop down list.
  5. Set the appropriate value e. g. 1000 for the field Where N is:
  6. Click on OK.
  7. Insert the Cross-tab in the report.
  8. It shows the different sequence as appears in the chart.

Resolution

  1. Right Click on Cross-Tab and select Cross tab Expert.
  2. Insert the field in Rows section on which the sorting is performed in the chart.
  3. Right click on one of the row header e. g. "Customer name".
  4. Select Row Options > Row Group Sort Expert.
  5. Select Bottom N for displaying data which is in ascending order in the chart OR Top N for displaying data which is in descending order in the chart from drop down list.
  6. Set the appropriate value e. g. 1000 for the field Where N is:.

It shows same result as appears in the chart.

Note: The option Row Options > Row Group Sort Expert is only available for Rows in the Cross-Tab, the same option is not available for columns.

Keywords

Crystal Reports, CR, Cross tab, Chart, Sort, Order, Sequence , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011

Attachments

Chart.png
Cross tab.png