How to make Gridview control to group in each column of data?

[Peter]

How to make Gridview control to group in each column of data?

Hi, I have a web project which uses webform with Gridview to display the SQL server table data,

Data in Gridview Control is as this grid format:

Data 1 | Data 2 | Data 3 Amount1 Amount2 Amount3

Data 1 | Data 2 | Data3 Amount1 Amount2 Amount3

Data 1 | Data 2 | Data 3 Amount1 Amount2 Amount3

Data 1 | Data 2 | Data 3 Amount1 Amount2 Amount3

Ground Total: Gtotal1 Gtotal2 Gtotal3

I expact the data to be shown in the report in this way:

+Data1 Subtotal1 Subtotal2 Subtotal3

Ground total Gtotal1 Gtotal2 Gtotal2

Click +Data1 to expand it, it should be:

-Data1 Subtotal1 Subtotal2 Subtotal3

+Data2 SecondSubtotal1 SecondSubtotal2 SecondSubtotal3

Gtotal1 Gtotal2 Gtotal3

Click +Data2 to expand it, it should be:

-Data1 Subtotal1 Subtotal2 Subtotal3

-Data2 SecondSubtotal1 SecondSubtotal2 SecondSubtotal3

+Data3 ThirdSubtotal1 ThirdSubtotal2 ThirdSubtotal3

Gtotal1 Gtotal2 Gtotal3

Click +Data3 to expand it, it should be:

-Data1 Subtotal1 Subtotal2 Subtotal3

-Data2 SecondSubtotal1 SecondSubtotal2 SecondSubtotal3

-Data3 ThirdSubtotal1 ThirdSubtotal2 ThirdSubtotal3

DetailsAmt1 DetailsAmt2 DetailsAmt3

Ground Total Gtotal1 Gtotal2 Gtotal3

Of cause, the + and - sign in the report will be able to expand and collapse.

After did some search from the internet, somebody mention Jqgrid, or telirik tool, etc. but most of them are only works on first level of group, not more than one group, I appricate anybody can provide any solution to achieve this goal. Some examples will be helpful