I have a question regarding subreport totals. I have a subreport that has a manual running total and I would like to pull the total from the subreport because I would like to take this total and subtract it from a field in my main report. The problem is I cannot get the formula to display on my main form. I can place the subreport into my main report and the totals are correct but it just displays the data I can only read it and not really use it. Does that make sense?
I think the way my report is grouped could be the problem.
My main report is grouped accordingly
G1 AccountType
G2 AccountGroup
G3 Account
The subreport is grouped accordingly
G1 AccountCategory
G2 Account
The subreport displays all the correct data for each account. The numbers are correct that display on the main report from the subreport. I would just really like to use the total I am seeing on the subreport. It is a @display and placed in groupfooter2 of the subreport. Any help would be greatly appreciated because I have no clue as to what I am doing wrong.