Summarizing variables field with calculations
I have three fields which I need to summarize, as a group summary, then a grand total. The first field, Total_STD_Labor_Cost, is in a sub-report, which is a calculation and stored in a "Receipts" variable field. I then multiply Receipts*STDCost=Total_STD_Labor_Cost. This results, I can pass to the main report, but can not summarize it, regardless where it is placed in the main report, report footer or any group footer. The second and third fields are in the main report and are calculated using the "Receipts" variable field and cost fields. I can not summarize these two field either, I suspect because they include the "Receipts" variable field is why I am not getting any results. Running totals do not seem to work or apply here. So I am looking to either capture the sums of the fields by group and again in the grand total. Using the insert summary feature does not give the sum option.
Any thoughts would be truly appreciated.