Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: Eliminating Replication Post Reply Post New Topic
Author Message
NCGOV
Newbie
Newbie
Avatar

Joined: 04 Oct 2016
Online Status: Offline
Posts: 23
Quote NCGOV Replybullet Topic: Eliminating Replication
    Posted: 11 Mar 2020 at 3:01am
I am looking to create a report that includes a parent table and multiple child tables.

I have grouped the parent table by the system ID and subsequently grouped the child tables by their system ID.

I Do Not want to use sub-reports.

The child table data replicates for each entry. How can this be corrected with formulas and/or parameters?

I do not want to use the suppression formula of "{table.field}=previous{table.field}

Sample Data -
Parent table Data
Child table1 Data1

Child table2 Data1
Child table2 Data2

Child table1 Data2

Child table2 Data1
Child table2 Data2

Child table1 Data3

Child table2 Data1
Child table2 Data2


Goal -
Parent table
Child table1 Data1
Child table1 Data2
Child table1 Data3

Child table2 Data1
Child table2 Data2
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1523
Quote kevlray Replybullet Posted: 11 Mar 2020 at 9:18am
Depending on the data source and how good you are writing SQL code.  You probably could achieve the results you want.  You would have write sub-queries.
IP IP Logged
NCGOV
Newbie
Newbie
Avatar

Joined: 04 Oct 2016
Online Status: Offline
Posts: 23
Quote NCGOV Replybullet Posted: 11 Mar 2020 at 9:26am
I am a novice and have no idea how to accomplish this. Wacko
I have all of the links going from the parent table to the child tables, left outer join.

The one to many is really tough. I am struggling to figure out how to accomplish my goal.

IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1523
Quote kevlray Replybullet Posted: 12 Mar 2020 at 4:12am
Unfortunately without knowing more about the particular database and the table structure along with the columns and join information.  It would be very difficult to assist.  There is a ton of information available on the internet.
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.