Crystal Report
Olivier Astier ( "Olivier )
Thu, 25 Jun 1998 10:24:27 -0700
Hi all,
In order to detect modems failures I wrote an SQL query that shows, for the
NAS Port that are currently unused, the last time the port was used (the
last time someone logged off)
I would like to create a Crystal Reports that displays the same results (I
use Crystal Reports 4.6) but I can't figure out how to do the "SELECT
MAX(CallDate)" through CR.
There may be a way to do the query differently so that it would be easier to
import in CR
Any help would be really appreciated.
Thank you for your attention.
Oliver
EchoWeb LLC.
The query is :
SELECT c1.NasIdentifier, c1.NasPort, MAX(c1.CallDate)
FROM Calls c1, Calls c2
WHERE c1.AcctStatusType=2
AND c2.AcctStatusType=1
AND c1.NasIdentifier=c2.NasIdentifier
AND c1.NasPort=c2.NasPort
GROUP BY c1.NasIdentifier, c1.NasPort
HAVING MAX(c1.CallDate)>MAX(c2.CallDate)
ORDER BY c1.NasIdentifier DESC, c1.NasPort