Summarize data
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13073
Printed Date: 23 Apr 2025 at 1:13pm
Topic: Summarize data
Posted By: Menno
Subject: Summarize data
Date 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.
Cheers,
Menno
|
Replies:
Posted By: hilfy
Date 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.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: Menno
Date Posted: 03 May 2011 at 10:37pm
|