Page 1 of 1

how to bind 2 details and relastion in subreport?

Posted: Tue Feb 23, 2010 10:02 pm
by RickyHuang
I have 3 Table
1.OrderMaster
2.OrderDetail
3.Employee

report:
Master Report-OrderMaster Info
SubReport1-OrderDetail List
SubReport2-Empoyee Info

relation:
OrderMaster's OrderID-OrderDetail's OrderID
OrderMaster's EmployeeID-Employee's EmployeeID

SubReport1's relation can work,but SubReport2 doesn't

please tell me how to do it...

attach this VB Project
http://filesky.com/publish/24/61.aspx


Another exampler:
products will need a lot of suppliers and will be distributed to many different customers
I need a form with the function to list down all the suppliers and clients
Thank you...

how to bind 2 details and relastion in subreport?

Posted: Wed Feb 24, 2010 8:09 pm
by Edward
Hi

Please right-click in the report designer on relations 'MasterDetail' and 'MDEmployee'. Change NameInSource parameter as 'Relation1' and 'Relation2' accordingly. That relation names can not have the same name.

Thank you.

how to bind 2 details and relastion in subreport?

Posted: Thu Feb 25, 2010 12:22 am
by RickyHuang
oh...it can work

thanks for your help


how to bind 2 details and relastion in subreport?

Posted: Thu Feb 25, 2010 5:22 am
by Andrew
We are glad to help you.

Thank you.