Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hide Drill down

Status
Not open for further replies.

quinn23

IS-IT--Management
Jan 4, 2002
29
US
I'm currently using Crystal XIr2
I have a main report listing all automobile detail. I have a sub report that contains one group on AutomobileID. I've created several counts contained in the Group footer. This sub report will act as a summary view to be displayed in the master report.

I have placed the sub report in the page header of the main report and linked it on automobileID. This all looks great. I can see a summary view first followed by all the detail.
I'm trying to hide the "drillable function". When running the report the user can click on summary(sub-report) and drill into the sub report. I would like the summary to remain static, not drillable. My sub report does contain one group which I believe is envoking the drilldown.
Is there a way to make the subreport not drillable and only show the summaries?
Thanks in advance
 
In general, you can place a text box over a groupfield to prevent drilldown. Without a text box, if you suppress detail records, instead of hiding them, a drilldown would only allow you to drill to the current group instance, and details would be unavailable.

-LB
 
Thanks lbass
I did what you suggested but it still brings me into the subreport groupfooter where the summary counts are contained. Everything else in the sub report has been suppressed. I'm just trying to prevent the user from clicking at all on the sub report, the magnify glass shows.
 
Within the subreport, place a text box over the summary section.

-LB
 
Hi lbass
I have placed a text box over all the counts in the sub report which has eliminated the magnifying glass from showing in the main report but you can still drill into the sub report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top