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
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. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com