Jqxgrid

[lalit singhParticipant]

Hi ,

I am using aggregates on grid. my requirement is slight different. On grid statusbar
I have to forcibly specify some text like “<b>Grand Total</b>” : then i am calling function.

1. if i am putting like this aggregates: [{ ”: function (aggregatedValue, currentValue) { return aggregatedValue; } }], then “:” is coming. which i dont want to display
2. if i use aggregates[‘sum’], then it display as sum : some total value

i want to display direct aggregate value on status bar without “:” or any text. i want to display direct total value.

How to achieve this ?

Regards,
Lalit Singh

[Peter StoevKeymaster]

Hi Lalit,

To customize the rendering of the aggregates i.e to display whatever HTML you wish, please look at:
This sample: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/aggregatesrenderer.htm?arctic

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[lalit singhParticipant]

Hi Peter,

I agree what you replied. This was useful link. Here in link , still the word “sum”,”min”,”max” is displaying.

i want only value to be diplayed say for ex : 4956.00 for particular aggregate on status bar. no custom text, just number.

is it possible ?

Regards,

lalit singh

[Peter StoevKeymaster]

Hi Lalit,

It is displayed, because that it the returned HTML from the aggregatesrenderer. In that function, you implement what is the HTML to be displayed in the Grid.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[lalit singhParticipant]

Hi Peter,

Thanks for your reply.

I want to achieve below display

Account Cluster Sub-Segment Data owner Sales GM% Sales
MCBRIDE INT’L EUR CWE AntiP/Deo JBLU – – –
MCBRIDE INT’L EUR CEE Surface Care JBLU 13,555 50 13,455
MCBRIDE INT’L NEA CCN Air Care JBLU 6,808 50 6,708
MCBRIDE INT’L EUR CWE Oral Care (BC) JBLU – –
742,060 741,760

you can notice the value 742,060 (there is no text before “sum” or “;”)
, there is no text but only value on row summary. can we achieve this ?

regards,

lalit singh

[Peter StoevKeymaster]

Hi lalit,

Look at the function used for rendering in the example I pointed you:

     aggregatesrenderer: function (aggregates, column, element, summaryData) {
                          var renderstring = "<div class='jqx-widget-content jqx-widget-content-" + theme + "' style='float: left; width: 100%; height: 100%;'>";
                          $.each(aggregates, function (key, value) {
                              var name = key == 'sum' ? 'Sum' : 'Avg';
                              var color = 'green';
                              if (key == 'sum' && summaryData['sum'] < 650) {
                                  color = 'red';
                              }
                              if (key == 'avg' && summaryData['avg'] < 4) {
                                  color = 'red';
                              }
                              renderstring += '<div style="color: ' + color + '; position: relative; margin: 6px; text-align: right; overflow: hidden;">' + name + ': ' + value + '</div>';
                          });
                          renderstring += "</div>";
                          return renderstring;
                      }

The renderstring is the HTML displayed in the Status Bar. If you remove the following –name + ': ' +, Sum: would not be displayed.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[lalit singhParticipant]

Hi Peter,

I observed, i was missing columntype: ‘numberinput’ on my columns. Finally i added. Now Its working.

Thanks for your reponse.

Regards,

Lalit Singh

[Author]

Posts