Help filtering records
- From: "john wright" <riley_wright@xxxxxxxxxxx>
- Date: Thu, 8 Dec 2005 08:28:52 -0700
I have a report I am running and I want to select a distict date. I am
including the SQL statement and record select Formula info. Evertime I try
to use the Maximum function it tells me it is missing a boolean value. I
inherited this report and do not do much crystal reports. I am trying to
get the last record for @Edate for each person. Thanks.
John
SQL
SELECT
EVENTS."SERIALNUM", EVENTS."EVENTIME", EVENTS."EVENTTYPE",
EVENTS."EVENTID", EVENTS."MACHINE",
READER."TIMEATT",
EMP."ID", EMP."LASTNAME", EMP."FIRSTNAME", EMP."MIDNAME",
BADGE."FIRE", BADGE."MED", BADGE."HAZMAT", BADGE."HARESCUE"
FROM
{ oj (("EVENTS" EVENTS INNER JOIN "EMP" EMP ON
EVENTS."EMPID" = EMP."ID")
INNER JOIN "ACCESSCONTROL"."LENEL"."BADGE" BADGE ON
EVENTS."EMPID" = BADGE."EMPID")
INNER JOIN "READER" READER ON
EVENTS."MACHINE" = READER."PANELID" AND
EVENTS."DEVID" = READER."READERID"}
WHERE
EVENTS."EVENTTYPE" = 0 AND
(EVENTS."EVENTID" <> 2 AND
EVENTS."EVENTID" <> 3) AND
READER."TIMEATT" = 1 AND
(BADGE."FIRE" = 1 OR
BADGE."HAZMAT" = 1 OR
BADGE."MED" = 1 OR
BADGE."HARESCUE" = 1)
ORDER BY
BADGE."FIRE" ASC,
BADGE."HAZMAT" ASC,
BADGE."MED" ASC,
BADGE."HARESCUE" ASC
Forumla Editor
({EVENTS.EVENTTYPE} = 0 and ({EVENTS.EVENTID} <> 2 and {EVENTS.EVENTID} <>
3))
and {READER.TIMEATT} > 0 and {@EDATE} = CurrentDate and {READER.TIMEATT} =
1
and ({BADGE.FIRE} = 1 or {BADGE.HAZMAT} = 1 or {BADGE.MED} = 1 or
{BADGE.HARESCUE} = 1)
.
- Prev by Date: changing line's width at runtime
- Next by Date: Re: Crystal Reports and created with Visual Studio 2005 wont work on server
- Previous by thread: changing line's width at runtime
- Next by thread: Re: Crystal Reports and created with Visual Studio 2005 wont work on server
- Index(es):
Relevant Pages
|
