Attempting to Avoid Duplicates

[Krusher]

I've got this Oracle DB and I am attempting to write a Crystal report that summarizes linecosts for both materials and labor. There is a workorder table (WORKORDER), a labor transaction table (LABTRANS), and a material transaction table (MATTRANS). I am using left outer relationships for all joins. The problem is that, I have attempted to eliminate duplicates on either side, and have come up frustrated (even though I have done this in the past with other tables). For one of the workorder numbers, I've got 5 labor transactions and 26 material transactions. So the report just duplicates the labor transactions to match the material trasactions side. I'd like to see null values on the labor side to fill in the fields that don't match the material transactions side. Any help is greatly appreciated. Thanks in advance.

-K

 

[Turkbear]

Hi,
Try grouping on the Transaction number in the Workorder table and suppressing the group when any Materials fields is null.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

You could remove one of the tables and use a subreport for either labor or materials. Place this in the group footer for the workorder group, and link it on the workorder field.

-LB