Re: Reports

Dale E. Reed Jr. ( (no email) )
Tue, 23 Dec 1997 10:06:36 -0800

> 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