SAP Knowledge Base Article - Public

1572873 - How to sort Crosstab header with one field and display the other field in Crystal Reports.

Symptom

How to sort Crosstab header on one field and display the header on other field.

Environment

Crystal Reports 2008

Resolution

  1. Create a report with Crosstab using Customer table from Xtreme sample database.
  2. Go to Crosstab Expert. Select Customer Id for Columns and Country for Rows.
  3. Apply Count(Customer.Customer Id) under Summarized fields option.
  4. Select Customer Id from Columns and then go to Group Options
  5. In Common tab Select Customer Id from the Dropdown and the sort order as in ascending.
  6. Under Options tab, check the check box Customize Group Name Field. Select Customer.Customer Name from the dropdown.
  7. Press OK.
  8. The crosstab header will be now sorted with Customer Id and the header that is displayed is Customer Name.
  9. See the attached report Test.rpt.

Keywords

Crosstab sorting, Sort Column header on other field. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1

Attachments

Test.rpt