• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

crystal reports joins

How do you join sql server tables in the below scenario in crystal?

Table 1.
Table1ID(PK)
ReelNumber -accepts Table3 ChildReelNumber values or Table2 ReelNumber values

Table2
Table2ID(CPK)
ReelNumber(CPK)

Table3
Table3ID
Table2ID(CPK)
ReelNumber(CPK)
ChildReelNumber(values are based on column ReelNumber i.e if ReelNumbe is C2525 and tehre are five ChildReelNumber numbers each will be named C2525/1 ,C2525/2 etc etc)

My current link are giving duplicates based on the number of ChildReelNumber rows.

How can i sort this out?
0
NormanMaina
Asked:
NormanMaina
  • 4
1 Solution
 
peter57rCommented:
I don't understand the structure you are describing.

Please provide a brief description of each table and how it relates to the other two?
0
 
NormanMainaAuthor Commented:
0
 
NormanMainaAuthor Commented:
am hoping the above diagrams explain my problem.

The other way would be to create a formula to output data in the report depending on the printstage.
I tried that but still got the same results.
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
NormanMainaAuthor Commented:
I don't mind modifying the db if i have to.
0
 
mlmccCommented:
That is the way linking works.  Each record in a table is linked to each record in the other tables.  Since you have multiple records in one of the tables you will get multiple copies of the other fields.

One way around this in the report would be to put the information into the group header or footer so it is displayed only once.

mlmcc
0
 
NormanMainaAuthor Commented:
I had to make changes to the database design
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now