jqxgridjqxwidgets

How to display total of recordes in jqxgrid


I have jqxgrid.I am very new to jqxgrid.I want to display total of recordes or values in column. Can any tell me how to do enter image description here


Solution

  • jqxgrid have feature to show aggregates for some column, that aggregates could be 'SUM', 'COUNT', or 'AVERAGE'

    you can set the aggregates types when u set the column setting in jqxgrid declaration.

    for simple example is like this :

    // initialize jqxGrid
            $("#jqxgrid").jqxGrid(
            {
                width: 850,
                source: dataAdapter,     
                showstatusbar: true,
                statusbarheight: 50,
                showaggregates: true,
                columns: [
                  { text: 'First Name', columntype: 'textbox', datafield: 'firstname', width: 170 },
                  { text: 'Last Name', datafield: 'lastname', columntype: 'textbox', width: 170 },
                  { text: 'Price', datafield: 'price', cellsalign: 'right', cellsformat: 'c2', aggregates: ['sum', 'avg'] }
                ]
            });
    

    for custom aggregates, u can learn from this link http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/aggregates.htm?arctic

    for complete documentation for aggregates please check the API's documentation from their documentation.

    hope this helps