Problem with Expression in DataColumn

[Carl]

Hi,

I get errors when I try the following expression in my strongly typed
dataset:

"Sum(Parent.Child(Relation1).Value)"

The error I get is:

"Syntax error in aggregate argument: Expecting a single column argument with
possible 'Child' qualifier."

What I want to do is to navigate from the current row to its parent, and
then use one of the parents child relations to do a sum. It seems like
navigating more than one step is not supported. Can this be true?

regards

Carl

 

[WenYuan Wang [MSFT]]

Hi Carl,

As you see, I'm afraid this is true. The express column doesn't support
navigate the column more than one step. I think you may add a special
express column (Sum(Child(Relation1).Value) in the parent table and then
navigate to it from the child table(Parent.specialColumn).

Hope this helps.
Sincerely,
Wen Yuan
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Carl]

Thanks, I did like you suggested, and it works fine!

regards

Carl