Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Repeating Groups Post Reply Post New Topic
Author Message
tpreston
Newbie
Newbie


Joined: 26 Jan 2011
Online Status: Offline
Posts: 7
Quote tpreston Replybullet Topic: Repeating Groups
    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?

Edited by tpreston - 20 Jul 2023 at 11:19am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.047 seconds.