[CLOSED] Pivot Grid ( 1.*, 2.0)

[BATCCA]

Please confirm me if can exists a way to use the Pivot Grid ( included in extjs) with Ext.Net.

Than you.

[Baidaly]

Unfortunately, ExtJS 4 doesn't have this control, however you can look at following examples:

https://examples2.ext.net/#/GridPane...oupingSummary/
https://examples2.ext.net/#/GridPane...mnHeaderGroup/

Ext.NET 1.x doesn't have this control. However, you always can use following ExtJS 3 examples to implement it with Ext.NET 1.x , to do this you have to make it all on client side.

http://dev.sencha.com/deploy/ext-3.4...id/people.html

[Daniil]

Sencha is planning to implement a PivorGrid in ExtJS 4. But they don't provide any time frame.

It was expected in 4.1, but it didn't not appear.

There is an UX available for now.
http://www.sencha.com/forum/showthread.php?237492

[Richardt]

I also had a need for this, What I did, that is if you are using SQL Server, was to write a pivot query in a stored procedure and used the resulting information in ext.net gridpanel. Here is a link with examples on how to accomplish this. http://www.tsqltutorials.com/pivot.php

[Daniil]

@Richardt, thank you for the information.

[shaileshsakaria]

Sencha is planning to implement a PivorGrid in ExtJS 4. But they don't provide any time frame.

It was expected in 4.1, but it didn't not appear.

There is an UX available for now.
http://www.sencha.com/forum/showthread.php?237492

Is it third party control or its available with Ext.Net license itself.

Thanks
Shailesh

[Daniil]

Well, it is a UX extension and, essentially, it means a third party control.

[matrixwebtech]

Hi,
Recently I need a pivot grid and found this thread,I follow http://www.tsqltutorials.com/pivot.php and prepare data set.

dataset contains dynamic columns maybe 5-15 that's why I am not able to set predefined Store.
Daniil can you please assist me how do this?

[Daniil]

dataset contains dynamic columns maybe 5-15 that's why I am not able to set predefined Store.
Daniil can you please assist me how do this?

I could try, but I don't quite understand the requirement.

[matrixwebtech]

Ok
Let me explain,
I want to display "Employee wise Salary" in a grid.Salary generates based on salary component.
I f there are 3 types of employee Manager,Senior Developer and Junior Developer.May be Manager's salary depends on 15 salary component,
Senior Developer's salary depends on 10 salary component and Junior Developer's salary depends on 5 salary component.

I take Row wise data into column (Pivot with SQL).
So If I generates salary for all 3 types of employee the grid contain MAX 16(Employee name+15 salary component) column and if generate salary for only Junior Developer's grid contain MIN 6 (Employee name+15 salary component) column.

I see http://mvc.ext.net/#/GridPanel_Array...vent_Creation/ and I think I can produce a pivot grid with this.am I right?

My question is ,If I want to add some other functionally like
1. Export from grid.
2.checkbox selection
3.Row expander with another grid in it.
4.Grid print
5.Cell Editing(For this I need to add Editor in grid column)
6.Save All records from the grid.

please assists or give me some idea.