Re: [Emerald] Counting Calls
Josh Hillman ( (no email) )
Wed, 16 Feb 2000 09:37:19 -0500
From: Malcolm Joosse <firstname.lastname@example.org>
> Our beloved Telco has started charging timed calls illegally and it seems
> some of my modem customers have been affected.
> I have Emerald 2.5 and Crystal 7 pro but have no idea how to use Crystal
> except to design invoices.
> Can someone please tell me how I can extract the amount of calls by
> customers I know the info is there.
> Can someone please also point me to a how to use Crystal book or video
> I am currently counting the calls in the Time-On area and some are making
> >200 per month and it is taking awhile to count.
Maybe the SQL script below would help? Run it in ISQL (Query Analyzer in
select distinct UserName,
'Session Time (seconds)'=sum(AcctSessionTime)
and calldate between '1/1/2000' and '2/1/2000'
group by username
For more information about this list (including removal) go to: