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@...

----- 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

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

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

eGroups Sponsor

We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

[Non-text portions of this message have been removed]