We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Is PivotView similar to WebDataRocks?

Thread ID:





149891 Dec 13,2019 05:14 AM UTC Dec 19,2019 02:47 PM UTC JavaScript - EJ 2 5
Tags: PivotView
Asked On December 13, 2019 05:14 AM UTC

I am just getting started with the Pivot Table/View control in JS. All the demos I have seen seem to have a declaration for the rows, columns and values. Without which the pivot view does not render.
With WebDataRocks (or FlexMonster) control we are using, we just supply it with a JSON data and do not have to specify anything else.
Also, there is a Grid view in their pivot control. So I can just render the complete row/column data set in a table format.
In either case, there is no need to specify column or row names or value fields before hand.

This works great for us as we use it for dynamic data sets. Is this something that Syncfusion's JS Pivot Table/View can do?

Sivamathi Natarajan [Syncfusion]
Replied On December 16, 2019 08:47 AM UTC

Hi Johnny, 
Thanks for contacting Syncfusion support. 
As per the behavior of Syncfusion Pivot Table, an empty table will be rendered if data source alone specified in its report. Later you can specify columns, rows, filters and values dynamically in the report with the help of field list option. The pivot table will be refreshed based on the updated report. We have prepared a sample for your reference. 
Please check the below screenshot. Without row and column declaration you will get the empty grid view. 
We hope that the above sample will meet your requirement. 

Replied On December 17, 2019 08:48 AM UTC

Hi Sivamathi,
Thanks for the explanation. I was seeing the similar UI, but did not notice the field list option. Thanks for the sample. This works as I was hoping.
Another part of my question was to view the data in source as a regular row/column table. Is there a "mode" to do that with the PivotTable?

Sivamathi Natarajan [Syncfusion]
Replied On December 18, 2019 09:29 AM UTC

Hi Johnny, 
Thanks for the reply. 
We suspect that your requirement is to view the raw data in flat table like data grid control. But, the pivot table control doesn’t have option to display the flat table. But you can achieve your requirement by binding the raw data to data grid control externally. 
If the above response doesn’t matches your query then provide us more information about your requirement with screen-shots/video (if possible). 

Replied On December 19, 2019 08:52 AM UTC

Thanks for the reply. Grid view - that's exactly what I am after. But, I was looking for an integrated experience like in WebDataRocks.
In WDR I can switch between grid & pivot on the fly. For my use case, I keep my data in GRID mode by default. And user can modify the table as per their liking.

You can test out the demo they have on their website here:
This control has a LAYOUT option which enable the switching.

Sivamathi Natarajan [Syncfusion]
Replied On December 19, 2019 02:47 PM UTC

Thanks for the reply. 
Currently, the pivot table only supports “Excel-like layout”. But, we have planned to implement “Classics layout”. And, it will be available in any of the upcoming release. We will consider your requirement during the implementation. You can track the same by using the following link:   
We appreciate your patience until then. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon