Data Relations with Calculated Columns

[Brendan]

Hi Stimulsoft,
I'm not sure I am doing this correctly but is it possible to use Calculated Columns from a 2nd Depth Data Relation?

As an Example of 3 Tables:
Customers, Orders, OrderDetails


OrderDetails has a Relation to Orders has a Relation to Customers
OrderDetails -> Orders -> Customers

Customers has 2 columns, FirstName and Surname. I add a Calculated Column to Customers called FullName whose expression is Customers.FirstName + " " + Customers.Surname


Now if I add the OrderDetails as a Databand and add a Text Component with the Following:
{OrderDetails.Orders.Customers.FullName} I receive an error on compiling the report that says the following:
"Reports.Report.ParentCustomersRelation does not contain a definition for 'FullName'

I have included a vs.net 2003 sample if required which can be downloaded Here

[Vital]

Sorry, you can't use calculated columns in relation.

Thank you.

[Brendan]

ok, Thank you.