SAP Knowledge Base Article - Public

1196566 - How to hide a subreport to prevent user access


How do I hide a subreport to prevent user access?


In Crystal Reports XI, there is a need to prevent users from accessing subreports. The users must not be able to

  • drill down in to the subreport
  • double-click a subreport to open it in its own window
  • double-click the subreport area of the main report to open it in a new report viewer tab.


Here are the steps:

  1. 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. Press the space bar and Enter to fill the text object with blank spaces.
    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.


This method is applicable only to subreports that do not grow in size (for example, subreports that display only a chart or graph).

The text object can be formatted with a hyperlink to another report, another file, or a URL.


How to make a sub-report undrillable. , 2642723 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


SAP Crystal Reports XI ; SAP Crystal Reports XI R2