Hi,
I'm using a master-detail report and set the data relation between e.g. customer and order correctly.
Now when I run the report the report engine queries all the data from the child table and then does in memory filtering instead of using the relation information to only query the related child rows.
It shows up also in the query tracer from SQL Server that it loads the whole order table...
The problem is that my "order" table is about 400 MB as it contains images and a) it makes it very slow and b) it throws an out of memory exception.
How can I get around this please?
Thanks,
Patrick
Data Relations do only in memory filtering
Data Relations do only in memory filtering
Hi Patrick,
In such cases you have to use parameters in master-detail reports instead of relations. In the Demo.exe there is an example of such a report. Please go to 'SQL' - 'Master-Detail with Parameters' report.
Each time when detail datasource is being opened, parameters are set according to the master source and only required detail rows are fetched.
ReconnectEachRow property of the Detail DataSource is responsible for that. To access it, please select Detail DataSource and switch in 'Properties' window.
Thank you.
In such cases you have to use parameters in master-detail reports instead of relations. In the Demo.exe there is an example of such a report. Please go to 'SQL' - 'Master-Detail with Parameters' report.
Each time when detail datasource is being opened, parameters are set according to the master source and only required detail rows are fetched.
ReconnectEachRow property of the Detail DataSource is responsible for that. To access it, please select Detail DataSource and switch in 'Properties' window.
Thank you.