im using datareport. in that im using function control in the report footer to calculate the sum. but the field's data format if text and it is giving error data type mismatch. i tried changing the dataformat property to number. but it still giving error. pls help