Grouping Summary

QuestionsGrouping Summary
germanmary asked 9 years ago

Hi sir

Can we use custom data for grouping summary?

for example in third column need to get the sum(firstcolumn)/sum(secondcolumn)

how can we do it?

3 Answers
Abu Ghufran answered 9 years ago

Hello,

This is currently not supported in our product.
Infact it need some core level changes and may take time.

If you must have this function … you can check these links.

http://stackoverflow.com/questions/7600071/in-jqgrid-is-it-possible-to-use-different-formatter-on-grouping-summary-cell-ot
http://www.ok-soft-gmbh.com/jqGrid/SimpleLocalGridWithGroupingAndCustomFormatter.htm

As mentioned in link, you can have summaryType and formatter in grid in following manner.

$col["summaryType"] = "function (cellval, opts, rwdat, act) { … }";
$col["formatter"] = "function (val, name, record) { … }";

Navaneethan answered 9 years ago

Hi Abu,
I need grouping option without expand as default for that what can i do,pls help me for that

example:
[+]2007-10-01 – 1 Item(s)
Total: $120
[+]2007-10-02 – 1 Item(s)
Total: $360
[+]2007-10-03 – 1 Item(s)
Total: $240
[+]2007-10-04 – 1 Item(s)
Total: $150
[+]2007-10-05 – 3 Item(s)
Total: $294
[+]2007-10-06 – 3 Item(s)
Total: $2560

Thanks,
P.Navaneethan

Abu Ghufran answered 9 years ago

Set:
$grid["groupingView"]["groupCollapse"] = true;

Your Answer

3 + 20 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?