Another Report Question

LateText = IIF(DueDate < TodayDate,'Late',' ')
Insert LateText as field on record line.
TodayDate can = Today() function.

Or, to save column space on the report do the following:
LateDate = IIF(DueDate < TodayDate,DueDate,' ' )
NotLate = IIF(DueDate >= TodayDate,DueDate,' ' )
Insert BOTH fields exactly on top of each other and format LateDate to be
Bold (and maybe red). Spaces will overprint one or the other and if late it
will stand out on the report. Red on screen or on color print really shows
well.
-Todd C.

-----Original Message-----
From: sbeals@... [mailto:sbeals@...]
Sent: Monday, July 02, 2001 9:35 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Another Report Question


On my open jobs report, if the job is late, I would like it to state
this on the record field. Is there anyway to have the report do this
for you, say if the job was due 7/1, and today is 7/3, is their a
calcuation that will add the text late on the report.

Thanks again.

STeve


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> Note: You must have
already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.




[Non-text portions of this message have been removed]
On my open jobs report, if the job is late, I would like it to state
this on the record field. Is there anyway to have the report do this
for you, say if the job was due 7/1, and today is 7/3, is their a
calcuation that will add the text late on the report.

Thanks again.

STeve