Hi Experts,
How to get Sub Amounts "Sum" value in the Main Amount field as shown in the above picture?
Pls help me...
Oh, so this screen shot is just a mockup?
What I would do is use the InitializeRow event. In this event, you can check e.Row.Band and make sure the row is in the root band. If so, you need to get the value from the summary on the child rows and put it into the "Main Amount" cell.
To do that, you use something like this:
e.Row.ChildBands[childBandKey].Rows.SummaryValues[summarySettingsKey].Value
Thank you for ur reply Mike,
Well i made this picture to illustrate my problem clearly. It's like this I want to get the Child table's Sum in the Parent table's Main Amount Field(Pink colored field). So the user can get the Total of Sub charges rather than expanding the grid's child table.
How to get that? Pls reply.
I'm sorry, but I'm afraid I do not understand your question. It looks like you already have the sub-totals in the Main Amount field.