Report sum function 1

[ailyn]

I have a report with a loop in details. I.e., there is a subform that shows how many products where ordered within one order. So in one order I have two products with two prices.
Now I try to sum like I would do it on a form =Sum(([Price])+([Extras])) but it only gets the value of one of the items in the subform. How can I make it sum all the items of the subform?

 

[Remou]

Hi
Put your sum in the subreport Report Footer. Say this textbox is called txtSumPrice and your subreport control is called [Products subreport], you can reference it in your main report as:
=[Products subreport].Report.txtSumPrice

Please note that [Products subreport] must be the name of the control,not the report contained by that control.

 

[ailyn]

Thanks Remou! That was the problem. You should see how many times I retrid the form but I always put the subtotals on the page foot not on the report foot.
You earned a star XD