Report Writer Table Relationships

(0) Share

Report

Posted on by Community Member Microsoft Employee

I'd like to print MFG Notes on our traveler reports. The report table relationships are as follows:

MOP_Routing_Line
-Manufacture Order Master
--MFG Notes (I add this one to retrieve the notes)

When I add that last one, however, the report prints blank when there is no note. When there is a note, everything prints as expected.

When I look at the relationship between MOP_Order_MSTR and MFG_Notes, the only key is 'Note Index', relationship type is 'one record'. There are no restrictions on the report.

*This post is locked for comments

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Re: Report Writer Table Relationships

David,
That's exactly what the problem was.
Thank you very much.
David Musgrave MVP ... 13,926 Most Valuable Professional on at

Like (0)

Report

Re: Re: Re: Report Writer Table Relationships

Hi Joris

On the report defintion window, make sure Skip Blank Records is not checked.

David
Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Report Writer Table Relationships

I understand the concept of outer joins. However, this is report writer we're talking about here. I don't think I can just enter SQL anywhere.
Richard Whaley 25,195 on at

Like (0)

Report

Re: Report Writer Table Relationships

You need to use a Left Outer Join. (show everything on the left and ANYTHING that might exist on the right)