I would like to take the cash invoice total from the subreport and subtract it from the calculated payout from the cash drawer report giving cash drawer shortage/overage. 

 

I'm guessing I need to create a formula using a variable to hold the subreport data but I have no clue where to start.

 

Any help would be greatly appreciated.

 

Thanks in advance,

Cyber-guys

 

PS - this forum is the BEST !!!

 

I couldn't figure out how to get just the cash sum from the subreport so I created another subreport that selected only cash info.

 

I was then able to display the shared data in the subreport OK but couldn't get it to work in the main report.  I found that if I moved the subreport to the header it worked.  I don't need to display the contents of the extra subreport so I suppressed those fields & the report is working fine.

 

Obviously the issue was the order in which CR selects & processes data - is there any way to force the process in order to show data in the main report from a subreport located in a footer.  I have other reports that I need to do this with & I don't think my workaround will work.

 

Thanks again,

Cyber-guys