Another Brain teaser

Richard Sensale ( (no email) )
Tue, 16 Dec 1997 15:49:35 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_002C_01BD0A3A.358EBDD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Here's another weird one relating to reports.

I created a report using fields from two seperate tables.

MasterAccounts and SubAccounts

All they do is display login ID as well as creation date and start date =
filtered by Region and the referred by fields in MasterAccounts. Now =
all works well until I try to incorporate the payments table and show =
the amounts of any payments the user has made. As soon as I add in the =
new field for amount, the database doesnt give me any records. It's not =
the smart linking problem because all I have linked is the Customer ID =
field which is common to all three tables. This is annoying because I =
need to get it to show me the subtotals of all the payments for the =
users in that region and then give me a grand total to date. Im using =
crystal reports 4.5 so I dont know if that could have anything to do =
with it. CR 4.5 seems a bit lame sometimes. Any help appreciated.

------=_NextPart_000_002C_01BD0A3A.358EBDD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

Here's another weird one relating to =reports.
 
I created a report using fields from =two=20seperate tables.
 
MasterAccounts and =SubAccounts
 
All they do is display login ID as =well as=20creation date and start date filtered by Region and the referred by =fields in=20MasterAccounts.  Now all works well until I try to incorporate the =payments=20table and show the amounts of any payments the user has made.  As =soon as I=20add in the new field for amount, the database doesnt give me any =records. =20It's not the smart linking problem because all I have linked is the =Customer ID=20field which is common to all three tables.  This is annoying =because I need=20to get it to show me the subtotals of all the payments for the users in =that=20region and then give me a grand total to date.  Im using crystal =reports=204.5 so I dont know if that could have anything to do with it.  CR =4.5 seems=20a bit lame sometimes.  Any help =appreciated.
------=_NextPart_000_002C_01BD0A3A.358EBDD0--