SAP Knowledge Base Article - Public

1207094 - How to prevent users from being able to drill down into a subreport

Symptom

How to prevent users from being able to drill down into a subreport.

Resolution

This workaround is applicable only to subreports that do not grow in size. For example, subreports that display only a chart or graph.

1. In the Crystal Reports Designer of the main report, insert a text object over the subreport.

2. Resize the text object to be the same size or a little larger than the subreport object on the main report.

3. Fill the text object with blank spaces created by pressing the Space bar and Enter key. This is necessary because resizing a text object without the blank spaces will not maintain its size when it has been published on the Web.
 
Now, when the Crystal report is previewed on the Web, the text object that fully eclipses the subreport will prevent the ability to drill down into it.

Keywords

How to do drill down a sub-report. , 9606150 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports 9.0