You want to to a LEFT OUTER join to the sales order table so that all of the
records of the controling table print whether there is a linked record or
not. You will probaly also want to do a left outer join to the JOBAsmbl
table. This looks like a pretty complex report and an awful lot of joins,
good luck.
by the way how long does it take to run?
Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio
[Non-text portions of this message have been removed]
I am trying to add to an existing report on job cost. The current report
only shows jobs attached to a sales order ( contract - build to order) I
want to add jobs that are built to inventory with no sales order attached.
I proceeded to join the Part table with the JobAsmbl table using the partnum
field as the link. Jobhead is the master table. Other joins include:
When I try to print it says no records exist. I am sure it has to do with
the joining structure but I am not sure how it goes in this case. I am
still learning.
First, make sure the joins from jobhead to jobprod, jobprod to orderhead,
jobprod to orderdtl, orderhead to shipto and orderhead to customer are all
left outer joins. Then, you may want to consider linking the part table to
the job table (instead of job assmbl) depending on which part info you are
looking for. This should also be a left outer join.
Make sure your joins to the Order Information are
Left Outer. This means that you will get all job information
even if there is no order information. Hope this helps.
Tim Care
Electro Chemical Finishing
----- Original Message -----
From: "Darren Mann" <dmann@...>
To: "Vantage User Group (E-mail)" <vantage@egroups.com>
Sent: Friday, November 10, 2000 10:56 AM
Subject: [Vantage] RB Report Problem
> I am trying to add to an existing report on job cost. The current report
> only shows jobs attached to a sales order ( contract - build to order) I
> want to add jobs that are built to inventory with no sales order attached.
> I proceeded to join the Part table with the JobAsmbl table using the
partnum
> field as the link. Jobhead is the master table. Other joins include:
>
> Jobhead --> JobAsmbl
> Jobhead --> JobProd
> JobProd --> Orderhead
> JobProd --> OrderDtl
> OrderHead --> Shipto
> OrderHead --> customer
> JobAsmbl --> Part
>
> When I try to print it says no records exist. I am sure it has to do with
> the joining structure but I am not sure how it goes in this case. I am
> still learning.
>
> Regards
>
> Darren Mann
> Miller Products Co.
>
>
> 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.)
>
Also remember, for performance reasons, that each join must include the company field as the first element, since most indexes start with it. If you omit it, Progress will be unable to perform an indexed search, and must scan all records in the table to find the ones
of interest. This can really drag performance down if you are looking at large tables.
eg where jobhead.company EQ jobasmbl.company
and jobhead.jobnumber EQ jobasmble.jobnumber
and .......