How does Master-Detail work against the database?
Posted: Sat Feb 06, 2010 8:34 am
I wrote a simple Master-Detail report which works correctly. However, my concern is how the child datasource retrieves its data. Here is my setup:
I set up a Relation for "customerID".
When this report is executed does it pull all of the records from tblEmployees and then filter based on Relation? Or will it connect to the database and only pull records from tblEmployee that match the master data's customerID?
From a performance standpoint, I don't want it pulling all of the records from tblEmployees. I can add the WHERE condition to the child datasource, but I wanted to see if that was necessary.
Code: Select all
Master Datasource:
SELECT * FROM tblCustomer WHERE customerID=5
Code: Select all
Child Datasource:
SELECT * FROM tblEmployees
When this report is executed does it pull all of the records from tblEmployees and then filter based on Relation? Or will it connect to the database and only pull records from tblEmployee that match the master data's customerID?
From a performance standpoint, I don't want it pulling all of the records from tblEmployees. I can add the WHERE condition to the child datasource, but I wanted to see if that was necessary.