-----Original Message-----
From: Dale E. Reed Jr. <daler@iea.com>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
Date: Tuesday, December 23, 1997 1:09 PM
Subject: Re: Reports
>> Richard Sensale wrote:
>>
>> Hi I need some helpful suggestions as to how to go about designing a few
>> reports and was wondering if anyone had already done something like
these...
>>
>> I need a report which will list total dollars paid on account for any
period
>> of time (paid invoices). The tricky part is being able to define the time
>> period.
>
>Using Crystal Reports 5.0 or higher you can define paramters
>that you will be asked when the report is run. This allows you to
>specify the start/stop time. What you want to total is the Payments
>table for that customer.
>
>> I also need one that seperates billing by account type
>
>Same as above, but a triple join on Payments, MasterAccounts,
>and SubAccounts, grouped by SubAccounts.AccountType
>
>> And lastly I have to design one that can breakout how many dollars we are
>> billing for things like extra email addresses, or clients in different
>> regions.
>
>If its just straight regions, that one is easy (same three as above,
>just group by region, rather than accounttype.
>
>The extra stuff might be much more difficult. You'd have to dig into the
>invoice items table (5 table join) and pick out the matches you wanted.
>
>--
>Dale E. Reed Jr. (daler@iea.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>