Re: [Emerald] Counting Calls

Josh Hillman ( (no email) )
Wed, 16 Feb 2000 09:37:19 -0500

From: Malcolm Joosse <malcolm@hotline.net.au>
> 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
> etc....
> 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
SQL 7):

select distinct UserName,
Sessions=count(username),
'Session Time (seconds)'=sum(AcctSessionTime)
from calls
where acctstatustype=2
and calldate between '1/1/2000' and '2/1/2000'
group by username

Josh

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart