I already have a left-outer join - this gives me the majority of
suggestions with unknown job number. Any ideas?
Message: 24
Date: Thu, 14 Dec 2000 13:12:45 -0600
From: "Ted Kitch" <ted@...>
Subject: Re: Report Builder Purchasing Suggestions
Try a left-outer join to the JobHead, that should give you all of the
data you are looking for.
Ted Kitch
ted@...
suggestions with unknown job number. Any ideas?
Message: 24
Date: Thu, 14 Dec 2000 13:12:45 -0600
From: "Ted Kitch" <ted@...>
Subject: Re: Report Builder Purchasing Suggestions
Try a left-outer join to the JobHead, that should give you all of the
data you are looking for.
Ted Kitch
ted@...
----- Original Message -----
From: Nigel Roberts
To: 'Vantage User List (US)'
Sent: Thursday, December 14, 2000 3:42 AM
Subject: [Vantage] Report Builder Purchasing Suggestions
I wonder if anyone can help me, I'm trying to write a report showing
Purchasing Suggestions in Report Builder (the buyer 'doesn't like' the
system time-phase report!)
I've linked the SugPoDtl to the Jobhead table via Company and JobNum
fields (left outer join) but 95%+ of all the suggestions on my report
don't have a corresponding job number. When I view time-phase for a
particular part on screen, the dates and qtys tie up with my report
and
also show the related job numbers.
I suppose the question is - is it possible to show job numbers on
this
report as well or are these generated at run-time by code within the
system?
Thanks for any help in advance,
Nigel Roberts
MC Sheet Metal Limited