Error trying Dataset Aggregate Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to count and sum rows in a parent child relationship. I have a
strongly typed dataset with two datatables. I have defined the parent, child
relationship and in my bound datagrid, I have the ability to drill down as
expected.

When I try and add a column to the parent table with the expression :
count(child.StateAbbrev) where StateAbbrev is a field in the child table, I
get the error : Unbound reference in the aggregate expression
'count(child.StateAbbrev)'

I'm not sure what is not bound.

Any ideas?

Thanks,
Chris
 
No ideas, but I got a similar problem trying Max() and Min() with
Dataset.Select(). I think I remember seeing a doc that said these are not
supported, but I can't remember why. I fell back to getting Rows.Count.
 
Back
Top