Joined: 20 Feb 2014
Online Status: Offline
Posts: 5
Topic: Help Posted: 21 Feb 2014 at 9:24am
Hi,
I created a cross-tab totaling loan amount by month+interest rate. I then created a subreport with another cross-tab totaling trade amounts by month+ 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.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 25 Feb 2014 at 7:22am
There is no easy way to do this and it may not be possible at all. Subreports run a completely separate query from the main report and there is no way to return the whole dataset from the subreport to the main report other than possibly using an array (no guarantee that will work).
How are your SQL skills? If they're reasonably good, you could write a "command", which is nothing more than a SQL Select statement that will pull together both sets of data to get the values you need for the third cross-tab.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
