Hi
I have two bands in my UltraWinGrid, in the second band (child) every row has a status id.In my parent band I've created two unbound columns ( (col1 and col2), one for every possible status id
What I'm trying to achieve is that the ids of all child rows with Status id=XY get concatenated and shown in col1 (parent band).
is this somehow possible with formulas?
I don't see any way to do this with a formula. What I would do is handle the InitializeRow event of the grid. You can check row.Band.Key (or Index) to determine if the row being Initialized is in the parent band.If so, you can access the child rows via the e.Row.ChildBands[x].Rows and loop through the rows to build your concatenated string and then set the value of the appropriate cell in the parent row.
Hi Mike
Thanks for your answer, I'll try it with the InitializeRow Event.