Re: Creating a custom Crystal Report list users by Emerald Service Type.

Dale E. Reed Jr. ( (no email) )
Fri, 21 Feb 1997 03:10:06 -0800

Chris Murdaugh wrote:
>
> You've done a wonderful job with Emerald and I understand the Docs are
> still being revised - I would love any tips you could give on the shortest
> route to accomplish the following:
>
> I'd like to design a report to print the number of Users in each Service
> type (which I defined in Emerald Admin).
>
> I'd like the report to print 3 colums of Service types listing each users
> First,Last Name (and Login), ie. A column list of my users for 1 Hour Free,
> Hourly, and Monthly Service types and Total users at the bottom of each
> column.

I don't know if I quite understand the question, but just maybe. Try
this
SQL Statement:

-----
Select AccountType, LastName, FirstName, Login