Print Page | Close Window

Cross-tab

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=20502
Printed Date: 02 May 2025 at 2:14pm


Topic: Cross-tab
Posted By: kevmoc
Subject: Cross-tab
Date Posted: 20 Feb 2014 at 8:32am
Hi,
 
I created a cross-tab totaling loan amount by month and interest rate.  I then created a subreport with another cross-tab totaling trade amounts by month and interest rate.
 
Is there a way to subtract all the totals on the first cross-tab from the second cross-tab?  My goal is to creat a third cross-tab with the net totals.
 
Pleae let me know if this is possible.


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


Replies:
Posted By: DMD45
Date Posted: 29 Jul 2014 at 8:46am
Kev,

You would need to make the first one a subreport also.
Then create duplicate subreports of each one of those. The duplicates would have shared variable formulas to bring back to be used in the third cross-tab on your main report.

-------------
Dianne


Print Page | Close Window