Display Datagrid group Subtotals

[Kannan]

Hello,
I am trying to achieve something in this format in a datagrid...
Apologize if the drawing is not very clear...


Make Model Value
===== ===== ======
Toyota Tercel 16000
15500
-------------------------------------------------
Total Tercel 31500
--------------------------------------------------
Corolla 18000
19500
---------------------------------------------------
Total Corolla 27500
---------------------------------------------------
Total Toyota 59000

----------------------------------------------------
Ford Explorer 25000
32000
25000
----------------------------------------------------
Total Explorer 82000
----------------------------------------------------
Total Ford 82000


Basically I would like to print subtotals. I have achieved the
grouping of rows in the ItemDataBoundEvent... When I add a new
DataGridItem to contain the group totals, the whole output gets messed
up which leads me to think that I cannot create a new Item on
ItemDataBound event.

Can you guys give me any pointers to information that might be of
help. I would like to do this in one of the instrinic Datagrid events
(ItemDataBound or ItemCreated) and avoid the rollup operator or
changes to the underlying datatable as much as possible.

Thanks in advance

 

[Alvin Bruney [MVP]]

you wouldn't need to add a new item.
in your itemdatabound event, you would find the row in question and remove
all the columns in the row except one. Then you take that one remaining
column and use its row span property to stretch it across the empty columns.
You can fill text in there and right justify or customize it however you see
fit. You would need to do that for the very next row and enter ----- to
create the subtotal line. proceed in this manner until you have what you
want.

 

[Saravana [MVP]]

Check out this article, this will help you.
http://www.extremeexperts.com/Net/Articles/ExtendingDataGrid.aspx