This is a migrated thread and some comments may be shown as answers.

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

0 Answers 40 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Peter
Top achievements
Rank 1
Peter asked on 21 Nov 2012, 11:58 PM

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

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Peter
Top achievements
Rank 1
Share this question
or