GH2 - Category
GH3 - Contract No
GH4 - Billing Item
GH5 - Project Phase
I have a subreport in the GH5a section pulling in estimated cost at the phase level. I created a shared var and placed it in the report footer. I then placed the shared var in the GH5b section of the main report. I can see the amount. But I can't do anything with it. I need to sum the phases estimate at the Billing Item level(GH4), the Contract No(GH3), and the Category(GH2). I think I need to create another variable that creates a total of the passed shared variable. But I do not know what I am doing.
In the image the purple are my passed shared variables. I left the subreport with a border so you can see where it is. I place yellow highlights where I need the purple to total.
GH3 - Contract No
GH4 - Billing Item
GH5 - Project Phase
I have a subreport in the GH5a section pulling in estimated cost at the phase level. I created a shared var and placed it in the report footer. I then placed the shared var in the GH5b section of the main report. I can see the amount. But I can't do anything with it. I need to sum the phases estimate at the Billing Item level(GH4), the Contract No(GH3), and the Category(GH2). I think I need to create another variable that creates a total of the passed shared variable. But I do not know what I am doing.
In the image the purple are my passed shared variables. I left the subreport with a border so you can see where it is. I place yellow highlights where I need the purple to total.