Print Page | Close Window

Totals

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20498
Printed Date: 17 May 2024 at 8:42pm


Topic: Totals
Posted By: kevmoc
Subject: Totals
Date Posted: 20 Feb 2014 at 6:23am

I’m new to this, hopefully I makes sense.

 

I have a report with 2 tables: INC. and T.

 

The INC table is trade level data.  The T table is loan level data.

 

My goal is to subtract the total in loan amounts from the total in trade amounts.  (Sounds easy)

 

When I drop in the trades (from the INC table) and total them, it works perfect. 

Example: 3 trades at $1 million each.  Total is $3 million.

However once I drop in the loans (from the T table), the trade amounts  shows $1 million for each individual loan (not correct).  So if there are 2 loans in each trade, the trades are now totaling $6 million.  It should still be $3m.

 

Please help?

 

 



-------------
Kev


Replies:
Posted By: DBlank
Date Posted: 20 Feb 2014 at 6:40am

you likely have a unique identifier per row in each table.

You can use Running Totals with sum the values but in the evaluate option have it evaluate on change of field and select the primary key for in each table as the field. 

Posted By: kevmoc
Date Posted: 20 Feb 2014 at 7:03am
Ok, that seems to work. 
Thanks for your help.
 
I'm sure I'll be back for more help soon.


-------------
Kev


Print Page | Close Window