While in the CR2008 or XI 3.x DHMTL viewers, an end user can click on a subreport and drill down to that subreport. This will open the subreport in a new tab.
Sometimes a report developer will not want the end users to drill down on a subreport. There is no property in the Format Subreport dialogue that will disable this drill property. However, there are a couple of workarounds for this.
A) If the subreport does not span more than 1 page and you know the end size of the subreport, you can place Text Object on top of the subreport. Populate the new Text Object with spaces and breaks to ensure that the subreport is completely masked.
or
B) You can disallow drill-down on all sub-reports in a report using javascript.
Steps:
1) You must have Pass-Through HTML activated in your Enterprise or Crystal Reports Server environment. For more information on activating Pass-Through HTML please see the webElements download Crystal Reports webElements. There are instructions in the webElements User Guide which is in the download. By activating Pass-Through HTML a report developer can embed HTML or javascript directly on a Crystal Report.
2) Download the "Disallow Drill-Down In Subreports" sample report here. Press the "View this Code Sample" button to download the sample.
3) Open the sample report and copy the {@DisallowDrillDownInSubreports} formula in the Page Header onto an unsuppressed Page Header on your report.
4) Save your report back to your Enterprise or Crystal Reports Server environment. Drill-down on your report's subreports should now be disabled.
NOTES:
1) Activating Pass-Through HTML is supported in BusinessObjects Enterprise XI and higher. The javascript or HTML that you build on your report is not supported by Customer Assurance. Therefore this workaround is not supported by Customer Assurance.
2) If you want to disable drill-down on Group Summaries or Group Headers, please see Ray Li's blog Disable summary fields from drill down in Crystal Reports.
