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:
-
Insert a text object over the subreport.
-
Resize the text object to be the same size or a little larger than the subreport object on the main report.
-
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