In your Phrase builder when looking at the Table relations instead of
each try first. It should work.
Jim
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Tuesday, November 25, 2008 9:24 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Customer Report
I suppose if try to to set the OrderHead table to summarized (after
already having set up a entrydate criteria against it), the editor
squawks at you that this is disallowed (even though Progress supports
this)?
Depending upon your version, the lame home-made-by-a-twelve-year-old BAQ
editor may be able to be tricked.
If not, you're screwed. Do it in Crystal or odbc/SQL.
Rob
--- On Tue, 11/25/08, Jeff Stockard <jeff.stockard@...
<mailto:jeff.stockard%40rikerprod.com> > wrote:
From: Jeff Stockard <jeff.stockard@...
<mailto:jeff.stockard%40rikerprod.com> >
Subject: [Vantage] Customer Report
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Tuesday, November 25, 2008, 9:37 AM
I have made a BAQ using the Customer table and the OrderHead table. My
Sales manager wants to print labels, but he only wants to see them for
Customers that have made purchases since we have gone Live on Vantage.
When
I put in the criteria for my BAQ OrderDate > 01/01/2007, I only get
valid
Customers. The problem is that I get a line returned for every Sales
order
created since 01/01/2007 and the labels print 913 pages of mostly
repeated
Customers.
Does anyone know of a field that only gets populated after a Sales order
has
been created, but will only return one line? In Customer tracker, there
is
a field under the Financial tab that show YTD Invoice payments, but we
moved
into a new Fiscal year 25 days ago and this field will miss a lot of
Customers. Any ideas will be appreciated, thank you
Jeff
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
each try first. It should work.
Jim
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Tuesday, November 25, 2008 9:24 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Customer Report
I suppose if try to to set the OrderHead table to summarized (after
already having set up a entrydate criteria against it), the editor
squawks at you that this is disallowed (even though Progress supports
this)?
Depending upon your version, the lame home-made-by-a-twelve-year-old BAQ
editor may be able to be tricked.
If not, you're screwed. Do it in Crystal or odbc/SQL.
Rob
--- On Tue, 11/25/08, Jeff Stockard <jeff.stockard@...
<mailto:jeff.stockard%40rikerprod.com> > wrote:
From: Jeff Stockard <jeff.stockard@...
<mailto:jeff.stockard%40rikerprod.com> >
Subject: [Vantage] Customer Report
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Tuesday, November 25, 2008, 9:37 AM
I have made a BAQ using the Customer table and the OrderHead table. My
Sales manager wants to print labels, but he only wants to see them for
Customers that have made purchases since we have gone Live on Vantage.
When
I put in the criteria for my BAQ OrderDate > 01/01/2007, I only get
valid
Customers. The problem is that I get a line returned for every Sales
order
created since 01/01/2007 and the labels print 913 pages of mostly
repeated
Customers.
Does anyone know of a field that only gets populated after a Sales order
has
been created, but will only return one line? In Customer tracker, there
is
a field under the Financial tab that show YTD Invoice payments, but we
moved
into a new Fiscal year 25 days ago and this field will miss a lot of
Customers. Any ideas will be appreciated, thank you
Jeff
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]