You couldnt tell me how to get the creditcard number and expire date to come
up in the report as well as so the report only does from the 2nd of the
month to the following 1st could you :-)
~~~~~~~~~~~~~~~~~~~~~~~~~~
Don Barron
World-Link Internet
Email: don@world-link.com.au
Web: http://www.world-link.com.au
Thought of the Day:
NEWS! Iraqi head seeks arms
~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Thursday, 4 November 1999 4:09
Subject: Re: [Emerald] Crystal report
> Don Barron wrote:
> >
> > Looking for some help for a report that will report the same as:
> >
> > select Login,
> > (select
> > SUM(Calls.AcctsessionTime)
> > from Calls
> > where Login = Username
> > )
> > as Charge_In_Cents
> > from SubAccounts
> > where AccountType = 'Minute Charge'
> >
> > Notice this will report the amount owing on time usage at 60c/min.
>
>
> 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.
> You
> could also make the detail a drilldown (whether than hide) which
> would allow you to double click a username and see their details
> as well.
>
> You can add some formulas/etc to calculate the charge if you want as
> well.
>
> --
>
> 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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart