Print Page | Close Window

field sum

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23038
Printed Date: 01 Apr 2025 at 2:57pm


Topic: field sum
Posted By: elly00
Subject: field sum
Date Posted: 20 Jun 2023 at 12:17am
Hi

I've a codart field in the detail section and for each codart filed I've a total

Now I need for every codart found the sum of the total

so If I've in my details section

product    total

aaa          1
bbb          2
ccc           3
aaa         5
bbb         6


In the report footer I would like to have

aaa= 6
bbb=8
ccc=3

I think that the only way to obtain this is using two arrays but I don't know how to corretcly do that

Anyone have an example?

thanks


Replies:
Posted By: hilfy
Date Posted: 25 Sep 2023 at 9:45am
Actually, you could use a cross-tab in the report footer to get this, the Row field is the product and the column is the sum of the total. If you suppress the column and row grand totals, you should get what you're looking for.

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window