I have an RDD that powers a Job Traveler in Crystal. I added this relationship:
Because I wanted to add these to the raw mats subreport:
But now it skips material sequences with no issued mtl, which we don’t want. Can you do a left join in an RDD? I’ve tried everything I can think of in Crystal.
I should have added that the rows are there, I verified in the xml plus if I don’t add anything from PartTran to the form then all the materials show up.
Did you look to see where the tracker gets its data from? If it is stored in a table somewhere, I would think that would be easier than PartTran.
The RDD looks ok to me. “output” is Left outer join.
What do your joins in Crystal look like? I would suspect something in Crystal.
DaveO
Nailed it. One of the links in Crystal was inner. I am a doofus.
