jQuery Grid Plugin - jqGridForum

Topic RSS

Multi-level grouping summary mis-calculations or misplacement

13/07/2014
08:41

ricardo

Member

Members

Forum Posts: 3

Member Since:
13/07/2014

Offline

I have a jqgrid configurationÂ with three-level grouping and summary totals for revenue column.Â

It does wellÂ in terms of the desired grouping.

However, when it comes to summaries, only the two outermost level groupings are showing the correct sum total. The innermost group-levels are showing exactlyÂ the same summary value as the parent group-level when it shouldn't.Â

For example,

Group A has a revenue total of $8,000,000;

Group A1 has $4,500,000;

Both Group A1.i and Group A1.ii both shows $4,500,000 (same as the parent level group) , when it should be $1,500,000 and $3,000,000 respectively adding up to the parents total. Â Â Â Â

-Same pattern for all third-level groupings.-

I will appreciate all the help on this.

Â Here is the code:

jQuery("#48remote4").jqGrid(
{
data: result.ReportLines,
datatype: "local",
colNames:['LoB ', 'type' , 'Account Number', 'Service Code','Total'],
colModel:[
{
name:'LoB',index:'LoB', editable:true, align:"center",sorttype:'text', hidden:false
},
{
name:'Type',index:'Type', editable:true, align:"center",sorttype:'text', hidden:false, width:30
},
{
name:'AccountNumber',index:'AccountNumber', editable:true, align:"center",sorttype:'text'
},
{
name:'ServiceCode',index:'ServiceCode', align:"center", sortable:true, width:90
},
{
name:'NetRevenue01',index:'NetRevenue01',align:"right",summaryType:'sum', summaryTpl : '<b>{0}</b>',formatter:'currency', width:70
}
],
rowNum:1000,
rowList:[100, 200, 500, 1000],
height: 'auto',
width: 'auto',
pager: '#p48remote4',
sortname: 'AccountNumber',
viewrecords: false,
sortorder: "asc",
caption:"Annual Revenue Report",
grouping: true,
groupingView:
{
groupField : ['LoB', 'Type', 'AccountNumber'],
groupColumnShow : [true, false, true],
hideFirstGroupCol:true,
groupText : ['<b>{0}</b>'],
groupCollapse : true,
groupOrder: ['asc','asc','asc'],
groupDataSorted : true,
groupSummaryPos: ['header', 'header', 'header'],
showSummaryOnHide: [true, true, true]
},
footerrow: true,
userDataOnFooter: trueÂ

}

14/07/2014
17:57

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,
In order to do the full description can you please post the data which causes the problem?
Thank you

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

14/07/2014
19:11

ricardo

Member

Members

Forum Posts: 3

Member Since:
13/07/2014

Offline

Tony-

Here is the requestedData:

var ReportLinesÂ = [
 {Lob:"VOIP REVENUE",Type:"COMMERCIAL INCOME",AccountNumber:"97000-691-90-2",ServiceCode:"3300::H9",NetRevenue01:"1500000.00"},
 {Lob:"VOIP REVENUE",Type:"COMMERCIAL INCOME",AccountNumber:"97000-691-90-3",ServiceCode:"3300::K9",NetRevenue01:"3000000.00"},
 {Lob:"VOIP REVENUE",Type:"TELEPHONY INCOME",AccountNumber:"97000-691-90-4",ServiceCode:"3300::09",NetRevenue01:"1600000.00"},
 {Lob:"VOIP REVENUE",Type:"TELEPHONY INCOME",AccountNumber:"97000-691-90-5",ServiceCode:"3300::J9",NetRevenue01:"2900000.00"},
 {Lob:"DRONE REVENUE",Type:"TICKLE INCOME",AccountNumber:"97000-691-90-6",ServiceCode:"3300::P9",NetRevenue01:"1600000.00"},
 {Lob:"DRONE REVENUE",Type:"TICKLE INCOME",AccountNumber:"97000-691-90-7",ServiceCode:"3300::C9",NetRevenue01:"2900000.00"},
 ];

Please replaceÂ result.Reportlines with ReportLinesÂ in the data portion of the jqgrid.

16/07/2014
13:58

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Thank you for the test case.
I reproduce the problem. Will try to fix ASAP.

Kind Regards
Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

24/07/2014
12:54

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

I have fixed the problem in GitHub here.

Please let me know if you have difficulties to run and test the fix

Kind Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

31/08/2014
02:30

ricardo

Member

Members

Forum Posts: 3

Member Since:
13/07/2014

Offline

tony said
Hello,

Â

I have fixed the problem in GitHub here.

Please let me know if you have difficulties to run and test the fix

Â

Kind Regards

Tony-

Â Â Â Â Thanks For the Help.Â

Â Â Â Â I applied the suggested solution but It has NOT solved the problem. Â¿Could you please check again?

13/09/2014
12:58

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

There was more fixes on this. Please, if possible download all the code and use grid base, common and grouping modules (other modules can be requiered maybe)

If it is difficult for you I will send you the fixed version

Thanks

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
35 Guest(s)

Currently Browsing this Page:
1 Guest(s)