Pivot grid (Pivot table) on roadmap?

Maybe I am the only one, but since I am using the community edition (free) version of Jasper which is a much fuller featured version of our current report writer, and since it is realativly easy to call a jasper report from within Aware, I would not be upset if there was no report writer included in Aware.

If we were negotiating (sort of like Trump with his "beautiful" trade deals), I would trade in the report writer for:

• Greatly improved inline editing function

• Not just a WYSIWYG Editor, but enhancements with HBoxs / VBoxes, Toolbars, etc. to make designing worldclass looking forms fast and easy

That, to me, seems like a good trade(deal)

Bruce

BLOMASKY wrote

Maybe I am the only one, but since I am using the community edition (free) version of Jasper which is a much fuller featured version of our current report writer, and since it is realativly easy to call a jasper report from within Aware, I would not be upset if there was no report writer included in Aware.

If we were negotiating (sort of like Trump with his "beautiful" trade deals), I would trade in the report writer for:

• Greatly improved inline editing function

• Not just a WYSIWYG Editor, but enhancements with HBoxs / VBoxes, Toolbars, etc. to make designing worldclass looking forms fast and easy

That, to me, seems like a good trade(deal)

Bruce

Would be great with a new report builder but for the love of god don´t take away the existing one if a new one isn´t implemented 😃. No trade!!!!

Support -- back before 8.0, you confirmed Pivot Grid is on the road map.

Could you give us a clue when you might be thinking it will get implemented?

http://www.telerik.com/kendo-ui/pivotgrid

Thanks!

It's on the roadmap, but whether it will be in 8.1, I am not sure yet

aware_support wrote

It's on the roadmap, but whether it will be in 8.1, I am not sure yet

When do you estimate, 8.1 will be available?? 🙂

Hopefully around January-February

Thanks support!

aware_support wrote

Hopefully around January-February

Thank you support.
This make me ask the second question 🙂 (I'm sure I'm not the only one)
What features will include 8.1?

aware_support wrote

Hopefully around January-February

It's hard for me to hide my passion for Aware, so I want to add my last two cents to shed some light or help 8.1 to shape in.

You can't avoid noticing (at least as a contractor looking for jobs) that more and more companies switching to REST service for a specific situations.
Building apps like the way Aware does currently will be around for a while. This is where most internal and registered users use the app on regular basis.
But what lots of companies are doing, is to extend their reach to other systems or other types of Mobiles by offering their data "SECURELY" via REST service to expose their system. Just offering an Unsecured REST service has no value to the developer. It's like you sell a house but has no locks and wide open. No one is going to buy that house.

Aware needs a full scale and secure way to expose an app via REST service, so companies can use Aware as a complete solution to build app and REST Service. THIS IS THE FUTURE OF AwareIM.

I humbly request that Aware's team, do this feature the right way, so it will meet the REST standards.
Thanks!

Its the FESTival for the RESTofus........ "costanzo"

Jaymer wrote

Its the FESTival for the RESTofus........ "costanzo"

Jaymer, you must be Italian... 😃

BTW, that Kendo Pivot Table is pretty amazing.
Esp. if you allow filtering (which not ALL the examples did)... and you notice that the tiny demo window has a scroll bar way at the bottom which allows you to see stuff all the way to the right. Initially, I didn't see that (cause its off my screen to the bottom) and didn't really understand what was happening when I was drilling down... but all that new data was being pushed RIGHT and it all makes sense now 🙂

Its cool that this understands native DATE data types - that way Months sort correctly in columns (in the past I've had to number column headings 1.Jan 2.Feb 3.Mar just to get the pivot columns correct.

I'd imagine that one issue will be formatting for printing - and maybe lack of control over page breaks, etc. People complain about issues in our ReportWriter and band issues, etc., but I bet you'll have even less luck using Pivot tables for stand alone super-polished reports.
As long as everyone realizes this is to analyze data - its a tool - and maybe not going to give you a finished product you'll put in the Annual Report, it will be a nice addition for sure.

Wondering if Pivot Table is going to make it into V9?

here's a pivot using ag-grid.com that I just put into an Aware form.

Wondering if Pivot Table is going to make it into V9?

here's a pivot using ag-grid.com that I just put into an Aware form.

When I queried support directly on this sometime back, they confirmed they were NOT going to be implementing a pivot. Not sure if they have changed their mind

I looked at ag-grid, it seems very impressive, did you hard code this or is it working off your AwareIM objects. I would like to implement ag-grid in some way, further advice would be appreciated

@[deleted]

try this

the 1st tab is the basic Olympic data shown in ag examples. its loaded as a .json file from their servers
the 2nd tab is live MSSQL data served via node.js

It took me about 30 mins (or under) to make add to my NodeJS file, and modify the aware BSV to add the 2nd tab, AND to config the column names, grid defaults.
because i'm new to AG-Grid, i don't have all the functionality setup. its late and i was up LATE last night too. Will tweak over time.

NO WAY, IMHO, a Kendo Grid could load these 5000 recs.
This doesn't do the 'lazy-loading', its loading all at once into the DOM.

(work in progress)

PS _ the long initial load time isn't due to the grid loading all the data... its the kendo.js, aware.js, highcharts.js files loaded the 1st time.
PPS _ I'm not happy with this data. not much to slice n dice on for the crosstab. will find better data.

have to admit, I don't understand why no one has commented on this.
This grid blows away the speed of a Kendo grid... the 2nd tab loads 5000 recs. That takes a LONGGGG time in kendo/normal Aware (if its even possible). Most of my "big" grids are massively sluggish past several 100 recs.

AND this does a pivot table.

I have a need for pivot tables.

Tables with the config.groupable turned on goes a quarter of the way there but the grid contains about 1,000 records and takes forever to render, so is a very very poor substitute

I also need:
Google maps as a query format
Tree view as a query format (not the directory listing tree view)

have to admit, I don't understand why no one has commented on this.

I am to blame :oops: , I hope to get back to this thread soon, just been buried in a mountain of work.

I have to get a pivot grid in place and this seems to be a solution, although the time I spent on your sample, I couldn't get it to perform as expected. I was under the weather at the time tho :cry:

Jaymer, I tried your example. Looks very good!
You wrote

a pivot using ag-grid.com that I just put into an Aware form

Can you explain how you did this?

ACDC wrote

I have to get a pivot grid in place and this seems to be a solution, although the time I spent on your sample, I couldn't get it to perform as expected.

please elaborate.
as i said, the data could be better on the 5000 rec tab.
the Olympic data is a bit easier to pivot.

feel free to hit me up on Skype (JaymerJaymer) so I can walk you thru it.