Joined: 02 May 2011
Online Status: Offline
Posts: 2
Topic: Summarize data Posted: 02 May 2011 at 2:15am
Hi,
I have a reports with a lot of relations, one table is my main tables which should show all items in my reports (the orders) - A - x - B - y - C - z
a connected table with a one-on-more relation should summarize the details (number delivered). The result should be that only one line is shown in my report - A - 1 - A - 3 - B - 3 - C - 5
the result should be: - A - x - 4 - B - y - 3 - C - z - 5
How can i mark the relation to "summarize"? en not to show me the seperate details.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 02 May 2011 at 9:05am
Group by order. Put your data in the group header and suppress the details section. Instead of putting the number delivered field there, insert a "summary" that will sum the number delivered. By default, Crystal will put this in the group footer, but you can move it to the group header.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
