Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
415
concatenating values from child band which have certain status id
posted

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?

Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    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.

Children