Problem in jqsPivotGrid

[Manu VashishthaParticipant]

Hello Sir
I am using Pivot Grid in my project. I have data in which ‘name’ and text property in datafields are different.
but in Pivot Table Designer when I drag field to Values Section then text of the field is showing the value of name property instead of text property.
For example it is showing:– “Count of firstname” instead of “Count of First Name”
var datafields= [
{ name: ‘firstname’, type: ‘string’ },
{ name: ‘lastname’, type: ‘string’ },
{ name: ‘productname’, type: ‘string’ },
{ name: ‘quantity’, type: ‘number’ },
{ name: ‘price’, type: ‘number’ },
{ name: ‘total’, type: ‘number’ }
]
var fields= [ { dataField: ‘firstname’, text: ‘First Name’ },
{ dataField: ‘lastname’, text: ‘Last Name’ },
{ dataField: ‘productname’, text: ‘Product Name’ },
{ dataField: ‘quantity’, text: ‘Quantity’ },
{ dataField: ‘price’, text: ‘Price’ },
{ dataField: ‘total’, text: ‘Total’ }
]
Kindly provide the solution to me.This is urgent.
Regards
Manu Vashishtha

[HristoParticipant]

Hello Manu Vashishtha,

Please, take a look at this example.
Let me know if you need anything else.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[Manu VashishthaParticipant]

Hello Sir

Thank you for your response.
I have checked the example given by you. This is working fine for grid. But I also need this functionality for pivot designer value area.
And also it is not possible for me to change the text on button click. I need any event like dragcomplete (lets assume when draging of a field is complete). So that I can change the text of particular field for pivot grid and designer both.

Regards
Manu Vashishtha

[Manu VashishthaParticipant]

Hello Sir

I also have one another requirement. I need data export functionality for pivot grid like jqxgrid.
Currently I am in need of ‘Export To Excel’ only.

Regards
Manu Vashishtha

[HristoParticipant]

Hello Manu Vashishtha,

There is no such functionality. Please, take a look at this section there are described possible features.
Also, I would like to suggest you look at this tutorial:
https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxpivotgrid/jquery-pivotgrid-introduction.htm?search=pivot

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[axe020Participant]

Hello Sir,

I am Using Pivot grid designer example and want to reinitialise the plugin once again on button how can i do it.
I tried using refresh method but its not working for me.

[Peter StoevKeymaster]

Hi axe020,

If you mean to create again the Pivot Grid, then you should do the following:

1. Remove the Pivot Grid’s DIV tag.
2. Append a new DIV tag.
3. Select the DIV tag and Run the initialization code.

Best Regards,
Peter Stoev

jQWidgets Team
https://www.jqwidgets.com/

[axe020Participant]

Thank you for your response.
It worked for me.

[Author]

Posts