Repeating Groups
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=23042
Printed Date: 18 May 2024 at 8:35am
Topic: Repeating Groups
Posted By: tpreston
Subject: Repeating Groups
Date Posted: 20 Jul 2023 at 10:15am
|
I have four groups. Each group is associated with a different table.
Group 1, Table 1: Fleet ID - a unique number that is never duplicated. All other tables are linked to this table by Fleet ID. Group 2, Table 2: PO Number - There may be multiple POs associated with each Fleet ID. Group 3, Table 3: Service Order - There may be multiple Service Orders associated with each Fleet ID. Group 4, Table 4: Sublet Reference - There may be multiple Sublet References associated with each Fleet ID. Currently, the report is duplicating Service Orders twice (because there are two POs), and duplicating Sublet References three times...twice...because there are three Service Orders and two POs. It looks like this... 
and I'd like it to look like this... 
Can you help? |
Replies:
Posted By: lockwelle
Date Posted: 07 Sep 2023 at 11:57am
|
I realize that this is a bit old.
I would try suppressing based on the current value being different from the PREVIOUS value It's a thought. |
Posted By: hilfy
Date Posted: 25 Sep 2023 at 9:54am
|
Because all of the data is joined to the fleet ID and there is no apparent relationship between PO, Service Order, and Sublet other than the Fleet ID, you'll need to use subreports for this. Here's how I would set up the data:
1. Main report - Group by fleet ID and show the PO data in the group header. 2. Add a fleet ID group header section below the one where the PO data is located. In that section add a subreport that shows the Service Orders and use the fleet ID as a subreport link to get the service orders for the specified fleet ID. 3. Add a third group header section and put a subreport that shows the Sublet Reference data, using the fleet ID as a subreport link to show just the sublets for the current fleet ID. -Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |