master-detail and "ReconnectOnEachRow=true"

[FrenkR]

I did some tests using "masterdetail relationship using ReconnectOnEachRow=true. Example is as attached.
Report is defined as follows:

ssPar11.png (47.92 KiB) Viewed 871 times

mdMachineCenter and mdWork have "ReconnectOnEachRow=true".
mdWorkCenter is "master SQL". others two are "details". mdMachineCenter is only defined inside report, but never used!.
Report had "double pass = true". Second pass is identified also in a report.
profiler shows following results for "first pass" only:

ssProfiler1.png (103.47 KiB) Viewed 871 times

SQL-s called with explanation:

ssProfiler2.png (41.5 KiB) Viewed 871 times

Report template and data from tables(sampledata.txt) are attached.

[Alex K.]

Hello,

Thank you for the detail description. We need some aditional time for check the issue.

Thank you.