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
jqgrid set grouped values into sumary row
09/08/2013
18:23
Avatar
renata
New Member
Members
Forum Posts: 2
Member Since:
18/05/2013
sp_UserOfflineSmall Offline

In my grid below i have 2 levels of grouping

[Image Can Not Be Found]

and my grid is

colModel:[ {name:'szGroupAccType',index:'szGroupAccType'}, {name:'szAccTypeId',index:'szAccTypeId'}, {name:'szAccNm',index:'szAccNm', width:500, formatter: function (cellValue, options, rowObject, actions) { if (options.rowId === "") { var names = [], data, i, l, item; if (options.rowId === "" && typeof actions === "undefined") { data = $(this).jqGrid("getGridParam", "data"); //here to set accounts on total } return cellValue; } else { return '<span style="display:inline-block;left:25px;position:relative;">' + cellValue; } }, summaryType:'count', summaryTpl : 'Total ({0}) '}, {name:'Balance',index:'Balance',align:'right',formatter: numberFormatter, sorttype:"float", summaryType:'sum', formatoptions:{thousandsSeparator:","}}, {name:'szAccCode',index:'szAccCode', hidden:true} ], grouping:true, groupingView : { groupField : ['szGroupAccType', 'szAccTypeId'], groupSummary : [true, true], groupColumnShow : [false, false], groupText : ['<b>{0}</b>', '{0}'], groupCollapse : false, groupOrder: ['asc', 'asc'], showSummaryOnHide: true },

i hv problem with this line

data = $(this).jqGrid("getGridParam", "data");

i've checked with firebug and var data is empty. Could you tell me where i did wrong? I'm trying to change total (in yellow) to Aktiva Tetap (110-...Bank dollar, 120- ... Bank rupiah) and total in grey with Asset (Aktiva Tetap (110-...Bank dollar, 120- ... Bank rupiah)) and so on.

Thanks in advance

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
57 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