Two tables report

chiav · Post by **chiav** » Fri Aug 31, 2007 6:50 am

Hi,
In DB got 2 tables: Customers and Orders. I've made relation between them: Cust_Order (Customer.CId->Order.CId). In report I want to show Customer.Name and Orders.Date. But it seem doesn't to work both then i'm using Master/Detail Wizard and putting {Order.Cust_Order.Name} into Report Designer DataBand. Need help.
Thanks.

fkmfkm · Post by **fkmfkm** » Fri Aug 31, 2007 7:30 am

I am trying to help. What doesn't work actually ?

chiav · Post by **chiav** » Fri Aug 31, 2007 8:27 am

I meant it shows empty spaces in place of {Order.Cust_Order.Name}

Post by **Edward** » Mon Sep 03, 2007 2:12 am

We've checked the Master-Detail Wizard. All works correctly. It seems that a relation do not work in case of your data. If you using version 2007.1, please check that fields which are involved in to the relation are of the same type. Version 2007.2 checks it is automatically.

If your efforts still are not successful, please send you data in any suitable format to

for analysis.

Thank you.