Data Relations with Calculated Columns
Posted: Thu Feb 22, 2007 5:15 pm
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
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