#7 Javascript/Ajax based JPivot

[João Fonseca]

Hi,

This feature request is probably too much work to consider, but I would like to at least raise the issue.

JPivot is too much invasive. To use it on a project we are required to:

-Use java
-Use JSPs (many use Velocity or FreeMarker as rendering engines)
-Put a ton of jars under WEB-INF/lib, and lots of other files also.

I think a better way to do this would be with Javascript based pivot table. To use it, some lines of javascript would setup the table, for example, telling it to draw itself under a given DIV. A similar approach is done on this library:

http://oat.openlinksw.com/index.html?pivot

And what about the data? With great care, the pivot table would access all data through a well defined interface, for example, named PivotTableDataModel.

Several implementations of PivotTableDataModel could then be provided. The first, and most obvious, would be to read inline data from the HTML document itself.

Other more powerful implementations would connect to a XML/A provider or web service to get the data.

This way, end-users would have the following benefits:

-Deployable with more programming languages - Ruby, Perl, etc.
-Easier setup - a few lines of javascript
-Better user interface - drag and drop dimensions across rows and columns, less screen refreshes, etc.
-Flexibility to use or build several PivotTableDataModel implementations depending on the project/product/programming language being used

I realize this is more or less like saying "drop the project, and start a new one". Feel free to ignore this.

Regards,
João Fonseca