<div>
I'm leaning towards the subreport. But out of curiousity, how would the array solution work?
</div>


I'm leaning towards the subreport. But out of curiousity, how would the array solution work?

<div>
I created a subreport. Thanks.
</div>


<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
I have a Crystal Report (v. 2011) that displays: customernumber, invoicenumber, invoicedate, itemnumber, productline, sales<br />
<br />
At the report footer I have running total for the sales column that I display in the report footer. But now we want to break that total down by productline. So if the report has 3 product lines then show 3 totals and the grand total (which is already there).<br />
<br />
Note, I don't know how many productlines will appear on the report, sometimes the report will display 3 productlines, sometimes it may display 5 or 1. It all depends on the parameters (invoice start date and invoice end date).<br />
<br />
How can I do this in Crystal Reports? Should I do a subreport just with the product line sales?<br />
<br />
Thank you in advance!
</div>
</div>


Hi all.

I have a Crystal Report (v. 2011) that displays: customernumber, invoicenumber, invoicedate, itemnumber, productline, sales

At the report footer I have running total for the sales column that I display in the report footer. But now we want to break that total down by productline. So if the report has 3 product lines then show 3 totals and the grand total (which is already there).

Note, I don't know how many productlines will appear on the report, sometimes the report will display 3 productlines, sometimes it may display 5 or 1. It all depends on the parameters (invoice start date and invoice end date).

How can I do this in Crystal Reports? Should I do a subreport just with the product line sales?

Thank you in advance!

Show totals for every instance of a specific field in the Crystal Report

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.