Problem to use relations with retrieveOnlyUsedData set as true
Posted: Fri Jan 31, 2020 3:35 pm
Hello,
Here is my issue : I want to setup a report with data from two linked datasource (using a DataRelation).
Also, I have set retrieveOnlyUsedData property as true to avoid having Stimulsoft querying my entire database when in this case only two tables are used.
It looks like the report cannot work if the retrieveOnlyUsedData property is set at true... I had to set it to false to have it working. But that means I have now tons of unnecessary queries being sent which I need to absolutely avoid.
Could you please help me with this matter?
Thank you.
Here is my issue : I want to setup a report with data from two linked datasource (using a DataRelation).
Also, I have set retrieveOnlyUsedData property as true to avoid having Stimulsoft querying my entire database when in this case only two tables are used.
It looks like the report cannot work if the retrieveOnlyUsedData property is set at true... I had to set it to false to have it working. But that means I have now tons of unnecessary queries being sent which I need to absolutely avoid.
Could you please help me with this matter?
Thank you.