I have a grand total footer in a report where I want to sum all values in a textbox called txtNet from a grouping footer. I named a textbox as txtNet in the grouping footer.
The query coming in is such that I must use and unbound control in the Grand Total Footer
I tried =[txtNet] as the control source in the Grand Total Footer and set the running sum to Over All.
Unfortunately it just gives me the last value in textNet not a running sum. How do I fix this?