GridCalculatedColumn and footer total calculation

4 posts, 0 answers
  1. Venkatesh
    Venkatesh avatar
    88 posts
    Member since:
    Nov 2012

    Posted 16 Jan 2013 Link to this post

    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
  2.
  3. Pavlina
    Admin
    Pavlina avatar
    6187 posts

    Posted 21 Jan 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  5. Koen
    Koen avatar
    7 posts
    Member since:
    Mar 2016

    Posted 21 Mar 2016 Link to this post

    That page no longer exists. Is there a similar solution somewhere?
  7. Pavlina
    Admin
    Pavlina avatar
    6187 posts

    Posted 24 Mar 2016 Link to this post

    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
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top