Hi, I am using asp.net WebForm to develop a website project, I am using Gridview to display grid data and report.
Now, my user needs the report to be able to group each column in their category and with each associated Subtotal, the total will be shown in last row. Something like this: (the data is a join 3 SQL SQL tables together)
Column1 Column2 Column3 Column4 Amount1 Amount2 Amount 4 ....
From Column1 to Column4 will be grouped (or cateogized), and each Amount column will show the subtotal of each group,
I know it may be hard to created only by plain gridview, I appreciate if anybody have any idea to achieve it.
I also searched Kendo UI (telirik) tools, it seems I can not get the exactly report as this requirement.
Thanks a lot,
...
Go to the complete details ...