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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">