Skip to Content
0
Former Member
Feb 19, 2009 at 03:53 PM

Main report is not display subreport total

244 Views

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.