Problem with Expression in DataColumn

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

v-wywang
Wed May 16 05:12:45 CDT 2007

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
Fri May 18 01:27:46 CDT 2007

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

regards

Carl

"WenYuan Wang [MSFT]" <v-wywang@online.microsoft.com> wrote in message
news:pVTaDL6lHHA.4032@TK2MSFTNGHUB02.phx.gbl...
> 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.
>