SAP Knowledge Base Article - Public

1571989 - How to show all the sections of the report When Drilling down on Group Headers?

Symptom

How to show all the sections of the report when Drilling down on Gruoup Headers in crystal Reports?

Environment

  • Crystal Reports 2008
  • Crystal Reports XIR2

Reproducing the Issue

  1. Create a report on Xtreme Sample Database.
  2. Insert the Customer table from the Database expert.
  3. Insert the field "Cutomer name" in the Details section.
  4. Click on the "Report" from the menu bar.
  5. Select "Group expert" from the list, Group Expert dialog box appears.
  6. Select country and region as two groups under "Group By" section.
  7. Refresh the report.
  8. Drill Down on Group Header1.
  9. We see only five sections(GH1, GH2, Details, GF2, GF1) appearing.
  10. We do not see Report Header, Report Footer, Page Header and Page Footer sections of the report.

Resolution

  1. Go to the "Design" tab of the report.
  2. Click on "File" from the menu bar.
  3. Select "Report Options" from the list.
  4. Check the checkbox "Show All Headers On Drill Down".
  5. Drill Down on any one Group Header.
  6. You will see all the sections of the report on Drill Down.

Keywords

All Sections, Drill Down, Group Header, Crystal Reports , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports Server 2008 V1