<div>
Hello,<br />
<br />
Please advice, how can I Hide/Suppress the subreport and do a count of records from the subreport to be passed into main report? <br />
Simply I need the count and not the Details. &nbsp;Thank you so much
</div>


Hello,

Please advice, how can I Hide/Suppress the subreport and do a count of records from the subreport to be passed into main report?
Simply I need the count and not the Details.  Thank you so much

<div>
<div class="content wysiwyg-content">
I have a report with the following layout:<br />
<br />
Details a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Field from SQL Command<br />
Details b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Field from SQL Command<br />
Details c &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Field from SQL Command<br />
Details d &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Field from SQL Command<br />
Details e &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SubReport A<br />
<br />
Report Footer b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SubReport B<br />
<br />
How do I add the total number of items in SubReport B + the total number of records displayed in Details a-d and display that value in the Page Footer?
</div>
</div>


I have a report with the following layout:

Details a 	Field from SQL Command
Details b	Field from SQL Command
Details c	Field from SQL Command
Details d	Field from SQL Command
Details e	SubReport A

Report Footer b	SubReport B

How do I add the total number of items in SubReport B + the total number of records displayed in Details a-d and display that value in the Page Footer?

Passing data between Main Report and Sub Report

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.