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!