RE: [Emerald] Counting Calls

Malcolm Joosse ( (no email) )
Thu, 17 Feb 2000 11:14:31 +1100

Josh,
Thanks for the reply.
What I need specifically is to be able to select a customer and then get
information on: the amount of times they dialed in, total connection time
(hh:mm) for a given period - dd/mm/yy -> dd/mm/yy, total data transfered -
in/out.

Thank you
Malcolm

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman
Sent: Thursday, February 17, 2000 12:29 AM
To: emerald@iea-software.com
Subject: Re: [Emerald] Counting Calls

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.

If you can be a bit more specific about what details you want, I can
probably provide a SQL script or two (I probably already have them) that
will do what you're looking for. Although I do have CR Pro 6.0, I usually
only use it to modify existing .rpt files...

Josh

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

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