SAP Knowledge Base Article - Public

1183424 - How to prevent drill-down on a subreport or Group Header section in Crystal Reports?

Symptom

  • How to disable a group or subreport drill-down?
  • How to prevent drill-down on a group or subreport in Crystal Reports?
  • How to prevent drilling-down when double clicking on a group or subreport when viewing a report in BI Launch Pad?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
          
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
  • SAP Crystal Reports for Enterprise 4.3

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Insert database fields on the report.
  3. Insert a subreport in the Report Header section of the report.
  4. When viewing the report in Crystal Reports or in BusinessObjects Enterprise, it is possible to drill-down on the subreport by double-clicking on the subreport.

Cause

  • This is a feature of Crystal Reports in which a user can drill-down on data in order to analyze it.
  • There is unfortunately no option to disable this feature in Crystal Reports.
  • This drill-down feature is also respected when the report is viewed in all viewers: Java, HTML.

Resolution

  • As workarounds to prevent drill-down:
    • Export the report to PDF format, and view the PDF document; or
    • Use a text object over the group or subreport
      •  
  • To prevent drill-down by using a text object:
    1. Open the report in Crystal Reports
    2. Insert an empty text field over the subreport or group header.
    3. Ensure the frame of the text box completely surrounds the subreport or group header frame

Once this is accomplished, Crystal Reports will no longer resolve the drillable element and the cursor will not change when rolling over those parts of the report. Note that this workaround has it's limitation, and if a subreport can grow, the text object will not cover the whole subreport, and it will then still be possible to drill-down on the subreport.

Keywords

drill cursor hand magnifying glass crystal report, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020