Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Sum of a column in footerData
06/02/2012
07:03
Avatar
mayankk
New Member
Members
Forum Posts: 1
Member Since:
06/02/2012
sp_UserOfflineSmall Offline

I want to have sum of a column in footerData. I am loading data from "mydata" Here is the code I am using

var colNames=["id","Name","Owner","Amount"];
var colModel=[
        {name: 'id',index: 'id',hidden: true},
        {name: 'Name',index: 'Name'},
        {name: 'Owner',index: 'Owner'},
        {name: 'Amount',index: 'Amount',align: 'right',sorttype: 'float',formatter: 'currency',summaryType: 'sum',
        formatoptions: {decimalSeparator: ",",thousandsSeparator: ",",decimalPlaces: 2,prefix: "$ "}}
    ];
var mydata=[
        {id="374", Name="QA", Owner="James Robert", Amount="100.00"},
        {id="374", Name="QA", Owner="Mayank Khandelwal", Amount="200.00"}
      ]

      jQuery("#list2″).jqGrid({
            data: mydata,
            datatype: "local",
            height:'auto',
            rowNum: 10,
            rowList: [10,20,30],
            colNames:colNames,
            colModel:colModel,
            pager: "#pager2″,
            viewrecords: true,
            sortname: 'name',
            grouping:false,
            groupingView : {
                groupField : ['Owner'],
                groupSummary : [true],
                groupColumnShow : [true]
            },
           footerrow: true
        });

I want to show a footer of Amount some thing like this "<b>Total: </b> $200.00″

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
33 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information