Sage 100

Stumped with crystal sub report totals. I have searched and can't seem to get it right. I am grouping by WT parent product line then parent item (jobops WT parent) have a sub report that totals all my components req/used/scrap by WT. My shared variable works fine. I want to total all my WT's to give me total by parent and would be great to get total by product line. I imagine I need a separate formula for each column (req/used/scrap). I found info to declare a global variable and then create a formula to calc var to use my global and shared var, then a separate formula to diplay it. I get all zeros doing that.

Be careful when you are declaring your shared variables (to flow data from the sub-report to the main report) to only reset when you want to.

Also be careful to not suppress where your global variable calculations are performed. (Hidden is OK, as is suppress blank section + suppress blank sub-report).