[Emerald] Report woes

Richard Sensale ( (no email) )
Thu, 11 Nov 1999 17:26:24 -0500

Hi folks, need some advice. I am trying to use Crystal Reports 6 to write a
report for my boss. I need to use the MasterAccounts, Subaccounts, and
chargetypes table to pull up a list of all users, sorted by pay periods,
with their pay method, expire dats, and services listed. I also need to have
listed what we are charging for each service with subtotals for those
amounts and a count of how many users in each pay period type. Problem
seems to be that when I try to link using the customerID between
masteraccounts and subaccounts, then using the description in subaccounts
and the chargetype table, I get no records returned. I remember a problem
with CR not being able to link more than one field across tables, I was
wondering if this is still an issue with newer versions of CR, or if there
is a work around for this problem?

Any help appreciated..

Richard Sensale
VisitUs Internet, Inc

For more information about this list (including removal) go to: