Summarizing Shared Var
Summarizing Shared Var
(OP)
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.

RE: Summarizing Shared Var
RE: Summarizing Shared Var
So the user group(executives) want the estimated totals(which feeds from the sub-report(boxed area) summarized in the group header areas as well.
I now pass the shared variable - but since I need to place them below - I am wondering how I can get the same format/layout/functionality.....
Thanks in advance.
I also seem to be having trouble with my passing of shared var on the division(group2) and Company(group1) level. But I am sure I am placing it wrong, or resetting something wrong, etc... So I am working on that.
But the formatting with using the shared is stumping me.
I almost wonder if I need to have a company level sub-report listing all and then pass the information below. But I would need to suppress the section and I didn't think you could do that either with a whileprintingrecords.
RE: Summarizing Shared Var
RE: Summarizing Shared Var
I can not figure out how to keep the format they want , and still pass all the variables.
RE: Summarizing Shared Var
RE: Summarizing Shared Var
This is hard to explain without more detail about the report, etc., but this is worth a try I think.
-LB