Hope this isn't duplicated. I tried to send this at 1:30. Still haven't seen
it.
************************************
Okay.
The Customer table has 1 record for each Customer, the Invoice Header table
has multiple records for each Customer.
Use:
Customer Table as your master (first table)
left outer join to Invoice header table
Customer as the Group Header and sort.
I think you can use the field Open Invoice in the Invoice header to do a
calculation.
For each Customer check the Open Invoice field for Yes or No. If it finds a
Yes you don't want that customer. You would print the Customer information
as a group summary or something like that.
Hope this helps gets you started.
Nancy
-----Original Message-----
From: sharma_nalini [mailto:sharma_nalini@...]
Sent: Monday, November 18, 2002 11:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: report filter
Yes I tried Left out join also both ways.
I tried with Customer as master table and left outjoin with invoice
table.
Invoice table as Master table and cutomer with left out join.
But still it show me the customers which have invoices in that month.
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
it.
************************************
Okay.
The Customer table has 1 record for each Customer, the Invoice Header table
has multiple records for each Customer.
Use:
Customer Table as your master (first table)
left outer join to Invoice header table
Customer as the Group Header and sort.
I think you can use the field Open Invoice in the Invoice header to do a
calculation.
For each Customer check the Open Invoice field for Yes or No. If it finds a
Yes you don't want that customer. You would print the Customer information
as a group summary or something like that.
Hope this helps gets you started.
Nancy
-----Original Message-----
From: sharma_nalini [mailto:sharma_nalini@...]
Sent: Monday, November 18, 2002 11:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: report filter
Yes I tried Left out join also both ways.
I tried with Customer as master table and left outjoin with invoice
table.
Invoice table as Master table and cutomer with left out join.
But still it show me the customers which have invoices in that month.
>have
>
> Hi I am trying to create a report for the customers who do nnot
> any invoice for the particular month.system
> i have a join between Customer and inv head table.
> customer.company to invhead.company
> customer.custnum to invhead.custnum.
>
> and i have a filter NOT invhead. invdate IN-RANGE 11/01/02 to
> 11/30/02.
> BUt i am still getting the customers which have invoice in the
> for particular month.must have
>
> What should i do.
> Is there ant other filter i have to Select or any other relation i
> ahave to make.
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> already linked your email address to a yahoo id to enable access. )Builder and
> (1) To access the Files Section of our Yahoo!Group for Report
> Crystal Reports and other 'goodies', please goto:http://docs.yahoo.com/info/terms/
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/