Data Relations do only in memory filtering

Stimulsoft Reports.NET discussion
Post Reply
patwolf
Posts: 90
Joined: Thu May 29, 2008 1:38 pm
Location: Los Angles

Data Relations do only in memory filtering

Post by patwolf »

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
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Data Relations do only in memory filtering

Post by Edward »

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.
Post Reply