DataColumn.Expression Filter on Child

  • Thread starter Thread starter flacmonster
  • Start date Start date
F

flacmonster

I have a field in a parent row that needs to be set to the sum of a
field in its children. That part is easy enough, as follows:

Sum(Child.ColumnName)

However, I need to filter out some of the children rows for the sum.
So what I want is something like this:

Sum(Child.ColumnName) WHERE Child.OtherColumnName = 'Some String'

I get an error which essentially states that there should be an
operand to the right of "Where"

Any ideas?

Kelly Smith
 
I don't think you'll be able to do it that way.
Instead I would do calculations myself.
 
Back
Top