We do some misc invoices where there is no matching shipment or sales
order, so the InvcDtl table will not have an order number to reference.
Your business may vary of course, and this may not matter to you.
An inner join says: only include invoice lines that have a matching
order detail line, and skip over invoices without a matching order.
Might upset your financial people if misc invoices start disappearing
from that report :-)
A left join, starting on InvcDtl, says: include all invoice lines,
regardless of whether we have a matching order or not. It will pull in
the order details if possible, or nulls/blanks if there is no matching
order.
Brian.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Thursday, July 21, 2011 8:29 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
It looks like I might have it working.
The only thing now is, in Crystal should the link start on InvcDtl > end
on
OrderDtl or vice versa?
And I would need to outer join it if we do misc invoices?
Thanks,
________________________________
From: Brian Roberts <broberts@... <mailto:broberts%40gfxltd.com>
Sent: Wed, 20 July, 2011 17:45:16
Subject: RE: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
From InvcDtl to OrderDtl, left outer join - I assume you have some misc
invoices with no matching order, so it has to be a left join.
But if I've guessed wrong, try this: start a new BAQ and add those two
tables, and see what relationship is automatically added between them.
Doesn't always work, but that's a convenient way to figure out table
relationships.
Brian.
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, July 20, 2011 12:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
Which way should the join go and what type of join?
________________________________
From: Brian Roberts <broberts@... <mailto:broberts%40gfxltd.com>
<mailto:broberts%40gfxltd.com>
<mailto:vantage%40yahoogroups.com>
Sent: Wed, 20 July, 2011 16:59:48
Subject: RE: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
In the Crystal report, use the Database Expert. In the Data tab, add
OrderDtl to the list of selected tables. In the Links table, drag
fields from an existing table to OrderDtl to establish the join you
want. Off the top of my head, try from the InvcDtl table to OrderDtl,
joining on Company, OrderNum and OrderLine.
Brian.
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, July 20, 2011 11:35 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
Thats what I thought. We are on 9.04.505C and OrderDtl is in the Report
Def but
in Crystal OrderDtl has to be pulled in manually and there are no joins.
Any suggestions?
________________________________
From: Karen Schoenung <kschoenung@...
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com> >
To: "vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> "
<vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Sent: Wed, 20 July, 2011 15:35:42
Subject: RE: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
On version 8.03.409C, the OrderDtl table is already a part of the ARForm
RDD...So, you expand the Report Table tree to show the OrderDtl table,
then
highlight the table and go to the Excluded Fields tab...Move Character01
from
the Excluded side to the Included side...
The relationship is already there.
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Chris Thompson
Sent: Wednesday, July 20, 2011 2:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
Hi All
I have a field (OrderDtl.Checkbox01) but I want to be able to export
this field
to Crystal when the AR Form is printed.
I know how to make a copy of the Definition etc but how do I create a
relationship between the tables etc?
Thanks.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
order, so the InvcDtl table will not have an order number to reference.
Your business may vary of course, and this may not matter to you.
An inner join says: only include invoice lines that have a matching
order detail line, and skip over invoices without a matching order.
Might upset your financial people if misc invoices start disappearing
from that report :-)
A left join, starting on InvcDtl, says: include all invoice lines,
regardless of whether we have a matching order or not. It will pull in
the order details if possible, or nulls/blanks if there is no matching
order.
Brian.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Thursday, July 21, 2011 8:29 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
It looks like I might have it working.
The only thing now is, in Crystal should the link start on InvcDtl > end
on
OrderDtl or vice versa?
And I would need to outer join it if we do misc invoices?
Thanks,
________________________________
From: Brian Roberts <broberts@... <mailto:broberts%40gfxltd.com>
>To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wed, 20 July, 2011 17:45:16
Subject: RE: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
From InvcDtl to OrderDtl, left outer join - I assume you have some misc
invoices with no matching order, so it has to be a left join.
But if I've guessed wrong, try this: start a new BAQ and add those two
tables, and see what relationship is automatically added between them.
Doesn't always work, but that's a convenient way to figure out table
relationships.
Brian.
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, July 20, 2011 12:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
Which way should the join go and what type of join?
________________________________
From: Brian Roberts <broberts@... <mailto:broberts%40gfxltd.com>
<mailto:broberts%40gfxltd.com>
>To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Wed, 20 July, 2011 16:59:48
Subject: RE: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
In the Crystal report, use the Database Expert. In the Data tab, add
OrderDtl to the list of selected tables. In the Links table, drag
fields from an existing table to OrderDtl to establish the join you
want. Off the top of my head, try from the InvcDtl table to OrderDtl,
joining on Company, OrderNum and OrderLine.
Brian.
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, July 20, 2011 11:35 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
Thats what I thought. We are on 9.04.505C and OrderDtl is in the Report
Def but
in Crystal OrderDtl has to be pulled in manually and there are no joins.
Any suggestions?
________________________________
From: Karen Schoenung <kschoenung@...
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com> >
To: "vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> "
<vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Sent: Wed, 20 July, 2011 15:35:42
Subject: RE: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
On version 8.03.409C, the OrderDtl table is already a part of the ARForm
RDD...So, you expand the Report Table tree to show the OrderDtl table,
then
highlight the table and go to the Excluded Fields tab...Move Character01
from
the Excluded side to the Included side...
The relationship is already there.
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Chris Thompson
Sent: Wednesday, July 20, 2011 2:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] How can I link OrderDtl in to the ARForm Report
Definition?
Hi All
I have a field (OrderDtl.Checkbox01) but I want to be able to export
this field
to Crystal when the AR Form is printed.
I know how to make a copy of the Definition etc but how do I create a
relationship between the tables etc?
Thanks.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]