Hi Thanks for your response.

The problem is with the display of value.It's of type VARCHAR only.

The value of the field in group footer is proper when viewed from Visual studio.

but...