Slow performance using Master-Detail with ODBC

HansHans
edited 7:02AM in FastReport .NET
We moved from XML data to ODBC databases to speed up performance.
The reports we use always contains a Master table with one or more Detail tables.
The problem seems to be that all the Details rows are retrieved and filtered by the report on the relatation at the end.
We found this thread at the forum, that seems to describe the same problem, however without a solution:
[topic="6795"]Master Detail Slow Preview, Master Detail Slow Preview after loading data form DB[/topic]

Is there a solution for this already?
We use version 1.6.64 at this moment.

Tia
Hans

Comments

  • AlexTZAlexTZ
    edited 7:02AM
    Hello,

    You may speed up the report by setting the master data band's PrintIfDetailEmpty property to true.
    wrote:
    The problem seems to be that all the Details rows are retrieved and filtered by the report on the relatation at the end.
    Yes, this is how the master-detail report is working. All detail rows are fetched and filtered using the master-detail relation.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2024