Re: [Emerald] Crystal report

Dale E. Reed Jr. ( (no email) )
Thu, 04 Nov 1999 10:48:13 -0800

Network Operation Centre wrote:
>
> Thanks heaps Dale, works like a charm now.
>
> 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 :-)

> > select Login, Calls.AcctsessionTime
> > from Calls, SubAccounts
> > where SubAccounts.Login = Calls.Username
> > and AccountType = 'Minute Charge'

You'd have to bring in the MasterAccounts table (linked via
CustomerID) and then you could display the CC information.

You can use the record select expert to limit the scope of
Calls.CallDate. There are several functions like last full month,
which might work.

-- 

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