RDLC - Report Data Item Join Type (INNER/OUTER)

(0) Share

Report

Posted on by Samantha73

3,255

Hi All,

When developing data sets for RDLC reports, is it possible to define the join type somewhat similar to Query object links where you determine if the join is INNER or OUTER?

Example:

dataitem(Customer; Customer)

{

PrintOnlyIfDetail = true;

RequestFilterFields = "No.", "Salesperson Code", "Search Name";

RequestFilterHeading = 'Customer';

dataitem("Sales Line"; "Sales Invoice Line")

{

DataItemLink = "Sell-to Customer No." = FIELD("No.");

SQLJoinType = INNER;

DataItemLinkReference = Customer;

The highlighted text above is not supported so are there any alternatives or how do people manage this kind of join?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 95,739 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Unfortunately, SQLJoinType property is only applied to Query Data Item.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-sqljointype-property

But if you really want to do that, there's an easy way to do it.
You can first create a Query (Using your SQLJoinType), then create a new Table, and finally set the DataItem as a new Table in the report and insert the values from the Query into the Table (which can be a temporary table).

I apologize for the lack of clarity and hope the links below will assist you.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/query/queryinstance-open-method

https://yzhums.com/4869/

Thanks.

ZHU

Was this reply helpful? Yes No