OT Crystal Reports [bayes]

[system]

Wouldn't you want to go by the Ship.dtl and look at the ship dates of
the line items?

John

-----Original Message-----
From: Abe Klassen [mailto:ak@...]
Sent: Tuesday, September 28, 2004 9:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT Crystal Reports [bayes]


I'm writing an efficiency report in Crystal and have a couple of issues
I could use some direction on.

(1) I am selecting the jobs by their ship date (ShipHead.ShipDate), if
there are multiple ship dates per job how can I select the latest ship
date?

(2) If the job is shipped complete 3 or more days ago but the job is not
closed I want to insert a warning flag. Is there a way to calculate the
difference between ShipHead.ShipDate and the current date?

Any help would be greatly appreciated.

Thank you,
Abe Klassen

[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
Yahoo! Groups Links