Changing Textbox Value in ItemDataBound property not affecting in Aggregation function (like SUM)

[Mitan]

Hi All,

I am changing Textbox.Value property on ItemDataBound evnet of Textbox 
for example TextBox.Value is 1000 but i want to change in some case to 55
but the sum function at GroupFooter is considering 1000 and not 55

is this possible ?? or its a wrong way???

Please HELP.....

Thanks in Advance.

[Stef]

Hello Mitan,

The total at the end most probably calculates an aggregate over w field value. Thus changing the TextBox item's Value, that represents the running value of the field would not be reflected by the underlying data and in the final calculation.

The recommended approach to change the TextBox.Value is via expression based on the built-in or custom functions. Events are not recommended due to the dependance of the order of rendering the elements - Report Events.

About the total, you can create a custom aggregate function or use a calculated field that via expression returns the desired value.

I hope this information helps you.

Regards,
Stef
Telerik