Datasheet

6.3.3.1 To hide details in a summary report
1.
Open your report in Crystal Reports.
If you haven't yet created a grouped and summarized report, open Group.rpt from the Feature
Examples samples folder.
2.
On the Report menu, click Section Expert to open the Section Expert.
3.
In the Sections list, click Details.
4.
On the Section Expert's Common tab, select the Hide (Drill-Down OK) check box.
5.
Click OK.
You'll notice the details are now hidden. To view the details, navigate through the report using the Group
tree, and then drill down on the appropriate area of the report.
Note:
For details on minimizing data transfer with summary reports, see Performing grouping on server.
6.3.4 Using subreports carefully
A subreport is an excellent way to include additional data in a main report. Performance issues relating
to subreports vary depending on the type of subreport used.
For general information on subreporting, see Subreports.
6.3.4.1 Taking advantage of on-demand subreports
If your report has a section that handles a large number of records, you can put that section into an
on-demand subreport. An on-demand subreport appears as a hyperlink in the primary report. When
you open the primary report, no data is retrieved for the on-demand subreport until you drill down on
the hyperlink.
For example, when designing a report that shows each employee's quarterly sales for each product
and each product type, you might also want to track each employee's progress by including weekly
sales information. This additional data, however, may not be of interest to many users viewing the
report. In such a case, extract the weekly sales portion of the report and attach it as an on-demand
subreport. Detailed information about weekly sales is retrieved from the database only when a user
drills down on the on-demand subreport.
2011-05-16113
Designing Optimized Web Reports