"How can I add a running sum to the report footer"

You could put the Sum() function in the detail area as a running sum in a hidden text box, and then refer to it in the footer.