Olivier Astier ( "Olivier )
Thu, 25 Jun 1998 10:24:27 -0700
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.
The query is :
SELECT c1.NasIdentifier, c1.NasPort, MAX(c1.CallDate)
FROM Calls c1, Calls c2
GROUP BY c1.NasIdentifier, c1.NasPort
ORDER BY c1.NasIdentifier DESC, c1.NasPort