SAP Knowledge Base Article - Public

1196566 - How to hide a subreport to prevent user access

Symptom

How do I hide a subreport to prevent user access?

Cause

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.

Resolution

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.

====================
NOTE:

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.
====================

Keywords

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

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2