The way you do this in Crystal, is:
select Login, Calls.AcctsessionTime
from Calls, SubAccounts
where SubAccounts.Login = Calls.Username
and AccountType = 'Minute Charge'
First, you group on the Login or username, and then hide the detail
section (the actual call record itself) and tell Crystal to do a
summary of the AcctSessionTime in the Footer for the username group.
could also make the detail a drilldown (whether than hide) which
would allow you to double click a username and see their details
You can add some formulas/etc to calculate the charge if you want as
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart