8
Currently the only way to implement an inner join or a left outer join between data items is using the PrintOnlyIfDetail property.
In Query objects there's a SQLJoinType property.
Why not also implement the SQLJoinType in reports, instead of the PrintOnlyIfDetail property?
Better control over joining data items results is smaller (and better) datasets, and so in better performance.
In Query objects there's a SQLJoinType property.
Why not also implement the SQLJoinType in reports, instead of the PrintOnlyIfDetail property?
Better control over joining data items results is smaller (and better) datasets, and so in better performance.
STATUS DETAILS
Needs Votes
Comments
This makes a lot of sense from consistency perspective.
Category: Reports and Business Intelligence
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team