We are using VBA to pull a field onto a GP report .
The VBA retrieves the value via SQL connection and returns the result to a Calculated Field.
The calculated field is in the body of the report and returns the correct data from the SQL /VBA.
However, when I add the calculated field to the Footer and code as SUM, it does not sum the values