(unknown)

system · June 19, 2002, 12:56pm

No. The calculated field "(OrderHed.orderdate = Max(OrderHed.orderdate)" is
testing for a "TRUE" condition. The result of the calculated field will
return either "FALSE" (when the order date does NOT equal the maximum date,
and TRUE when OrderHed.Orderdate = MAX ORDER DATE. You set your aggregate
to prepass so that it will run through the records first and find the
maximum date for that set of records. As it passes through the records a
second time the comparison is made to your Order Header field
"Orderhed.Orderdate". By setting the conditional printing to print ONLY
when a TRUE condition exists in the calculated field then only those records
that are the maximum date will be printed.

Shirley

-----Original Message-----
From: Mark Smith [mailto:mark_smith@...]
Sent: Wednesday, June 19, 2002 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)

Shirley,

You lost me there. I changed my aggregate, but after that I am not sure.
I
am going to have an aggregate and a calculated field both showing max
orderdate?

Mark Smith
IT Manager
Innerpac, Inc.
(708) 863-8300

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Wednesday, June 19, 2002 10:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)

Mark,
Try this. create an aggreagte field, Prepass, on order date
MAX(OrderHed.Orderdate) reset on order number. accumulate on every
composite.
Then create a calculated field "Orderhed.Orderdate =
MAX(OrderHed.Orderdate). The go into the band and set the conditional
print
seting to print when the calculated field is TRUE.
This should only print those order dates that equal the maximum orderdate.

Shirley

-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Wednesday, June 19, 2002 11:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] (unknown)

Hi,

I have been asked to create a report for management, which I have
been working on for the last couple of days, but can't seem to get it
just right. The report I am working on lists customer, ship to,
sales rep and last order date. I'm doing something wrong as I am
very close, but not sure what it is. Does anyone have any experience
with a report like this? I am really running out of ideas on how to
fix it (and patience).

Thanks,

Mark Smith

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 the Yahoo! Terms of Service.

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

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 the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

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 the Yahoo! Terms of Service.

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

system · June 19, 2002, 11:36am

Hi,

I have been asked to create a report for management, which I have
been working on for the last couple of days, but can't seem to get it
just right. The report I am working on lists customer, ship to,
sales rep and last order date. I'm doing something wrong as I am
very close, but not sure what it is. Does anyone have any experience
with a report like this? I am really running out of ideas on how to
fix it (and patience).

Thanks,

Mark Smith

system · June 19, 2002, 11:58am

Mark,
Try this. create an aggreagte field, Prepass, on order date
MAX(OrderHed.Orderdate) reset on order number. accumulate on every
composite.
Then create a calculated field "Orderhed.Orderdate =
MAX(OrderHed.Orderdate). The go into the band and set the conditional print
seting to print when the calculated field is TRUE.
This should only print those order dates that equal the maximum orderdate.

Shirley

-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Wednesday, June 19, 2002 11:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] (unknown)

Hi,

I have been asked to create a report for management, which I have
been working on for the last couple of days, but can't seem to get it
just right. The report I am working on lists customer, ship to,
sales rep and last order date. I'm doing something wrong as I am
very close, but not sure what it is. Does anyone have any experience
with a report like this? I am really running out of ideas on how to
fix it (and patience).

Thanks,

Mark Smith

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 the Yahoo! Terms of Service.

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

system · June 19, 2002, 12:25pm

Shirley,

You lost me there. I changed my aggregate, but after that I am not sure. I
am going to have an aggregate and a calculated field both showing max
orderdate?

Mark Smith
IT Manager
Innerpac, Inc.
(708) 863-8300

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Wednesday, June 19, 2002 10:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)

Mark,
Try this. create an aggreagte field, Prepass, on order date
MAX(OrderHed.Orderdate) reset on order number. accumulate on every
composite.
Then create a calculated field "Orderhed.Orderdate =
MAX(OrderHed.Orderdate). The go into the band and set the conditional print
seting to print when the calculated field is TRUE.
This should only print those order dates that equal the maximum orderdate.

Shirley

-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Wednesday, June 19, 2002 11:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] (unknown)

Hi,

I have been asked to create a report for management, which I have
been working on for the last couple of days, but can't seem to get it
just right. The report I am working on lists customer, ship to,
sales rep and last order date. I'm doing something wrong as I am
very close, but not sure what it is. Does anyone have any experience
with a report like this? I am really running out of ideas on how to
fix it (and patience).

Thanks,

Mark Smith

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 the Yahoo! Terms of Service.

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

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 the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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