[Solved] GridCalculatedColumn and footer total calculation

[Venkatesh]

Hi,

I have 2 numeric textbox, gridcalculated column and footer column.
Once the value is entered in the numeric textbox (something like onblur), i want to calculate the value for gridcalculated column and footer column. The lblTotalValue should have the total of the "GridCalculatedColumn".
This is the UI which I have:

<telerik:GridTemplateColumn UniqueName="OrderQuantity" HeaderText="Order Quantity" DataField="OrderQuantity">
            <EditItemTemplate>
                <telerik:RadNumericTextBox ID="txtOrderQuantity" runat="server" >
                </telerik:RadNumericTextBox>
            </EditItemTemplate>
        </telerik:GridTemplateColumn>

        <telerik:GridTemplateColumn UniqueName="UnitPrice" HeaderText="Unit Price" DataField="UnitPrice">
            <EditItemTemplate>
                <telerik:RadNumericTextBox ID="txtUnitPrice" runat="server" >
                </telerik:RadNumericTextBox>
            </EditItemTemplate>
            <FooterTemplate>
            <asp:Label ID="lblTotal" Text="Total: " runat="server"></asp:Label>
            <asp:Label ID="lblTotalValue" runat="server"></asp:Label>
            </FooterTemplate>
        </telerik:GridTemplateColumn>

            <telerik:GridCalculatedColumn DataFormatString="{0:C}" DataType="System.Double" HeaderText="Extended Price"
                UniqueName="ExtendedPrice" DataFields="OrderQuantity,UnitPrice" Expression="{0}*{1}"
                Aggregate="Sum" Visible="true">
            </telerik:GridCalculatedColumn>

How to achieve this?
Thanks

[Pavlina]

Hello,

I suggest you go through the forum thread below which elaborates on similar subject:
http://www.telerik.com/community/forums/aspnet/grid/radgrid-calculatedcolumn-based-on-templatecolumn.aspx

Greetings,
Pavlina
the Telerik team

[Koen]

That page no longer exists. Is there a similar solution somewhere?

[Pavlina]

Hello,

You can refer to the following articles:
http://www.telerik.com/help/aspnet-ajax/grid-totals-with-numerictextbox.html
http://www.telerik.com/help/aspnet-ajax/grid-totals-in-footers.html
http://www.telerik.com/help/aspnet-ajax/grid-using-getitems-getcolumn-methods.html​

and forum posts for more information on the subject:
http://www.telerik.com/forums/radgrid-group-footer-dynamic-calculation
http://www.telerik.com/forums/how-to-change-keypress-event-in-telerik-grid
http://www.telerik.com/forums/how-to-changes-telerik-grid-running-total-footer-template​

Regards,

Pavlina
Telerik