• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 40
  • Last Modified:

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

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!
  • 2
1 Solution
You could use a subreport.

Have you tried using a cross tab?
Rows would be the Product Line
Summary would be the totals

There is also a manual method of building arrays of the totals and the product line

printmediaAuthor Commented:
I'm leaning towards the subreport. But out of curiousity, how would the array solution work?
printmediaAuthor Commented:
I created a subreport. Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now