I'm working with a Trial Balance report, that simply returns a Year To Date balance for each account.

 

I need to convert that report to return only activity from a certain point in time.

 

Essentially, the report should continue to return the YTD balance, but then subtract the balance as of June 30.  So, if the balance at June 30 was "3", and the balance at the end of August was "7", the report would yield "4". 

 

In the subreport, which is just a list of accounts in the first column and balances in a 2nd column, I have the followong variable assigning the shared variable:

 

I am suppressing the sub-report.  I have it inserted in the main report section "Detail b".  I right-clicked that report section and selected "Suppress (No Drill-Down)".

 

For the test, I simply placed the variable along side the regular (non-subreport) data (which is just a list of account numbers).  

 

I suspect that part of my problem is that within the subreport, the variable data is associated with the account numbers, but when I import it into the main report, even though the accounts are all the same, I'm not sure that there is any way to maintain the association with thos numbers.

 

If that is a problem as I suspect, is there a way to bring the variable over in a way that it will maintain the association?

 

Thanks

 

I'll try changing the suppression, and if that doesn't work, I'll try the running total.

 

Thanks!