Mar 10, 2011, 4:24 AM
Grouping total rows
Hi
I need to get the total of all the rows in the data table. I tried the following demo trial
https://examples1.ext.net/#/GridPane...ping_TotalRow/
but i need to bind the data to the grid from the database.
I created a table as follows:
id group employees
-------------------------
1 aaa 21
1 aaa 32
1 aaa 26
2 abc 32
2 abc 12
2 abc 18
3 ccc 21
3 ccc 25
-------------------
I want the total as mentioned in the above link but i cannot able to read all the data with similar id.. that means im getting only the last value like this
id group employees
---------------------------
1 aaa 26
2 abc 18
3 ccc 25
------------------
What is the solution for that.....?????
I need to get the total of all the rows in the data table. I tried the following demo trial
https://examples1.ext.net/#/GridPane...ping_TotalRow/
but i need to bind the data to the grid from the database.
I created a table as follows:
id group employees
-------------------------
1 aaa 21
1 aaa 32
1 aaa 26
2 abc 32
2 abc 12
2 abc 18
3 ccc 21
3 ccc 25
-------------------
I want the total as mentioned in the above link but i cannot able to read all the data with similar id.. that means im getting only the last value like this
id group employees
---------------------------
1 aaa 26
2 abc 18
3 ccc 25
------------------
What is the solution for that.....?????