classical situation - tables customers, orders, order_details, need customer names and sum of orders in one grid, how to describe xpView property to feed the grid with required information?

customer
------------------------
id
name

order
------------------------
id
date
customer_id

order_details
------------------------
id
order_id
product_id
price
count

I'm facing the same problem, any suggestion would really help.

Hi,

 
    I have attached a simple application that does Sum and Counting for Order - OrderDetails

Hi, tnx for the reply but this isn't working for me, or at least isn't what i need. In my scenario I have an XPView mapped to Customer object type, and what i need is a property column inside XPView that maps to Orders[].OrderDetails[].Sum(Price) but this syntax isn't valid for a property. It accepts a property like Orders[].Sum(OrderDetails[].Sum(Price)) but then SQL Server throws an exception cause the sql query isn't valid.

Any other idea ? The main point is that i need all customers even if they have no orders.

tnx in advance

Luca

ok i get it.

   your xpView is refers to Customer. where customer has Order and OrderDetails. you want to get the sum and count for OrderDetails. if it is Order, then it would be something like

Orders.Count, Orders.Sum(?)

 
but how do you apply this concept to OrderDetails? surely

OrderDetails.Count, OrderDetails.Sum(?)

 
wont work when you are referencing Customer in XPView.
 

i dont think you can do this by simply assigning a property eval. but i have a workaround. see the updated attached file.