Data Item link AL

(1) Share

Report

Posted on by RB-10051553-0

I am trying to link Contact table with Contact Business Relation table, so I can find the related customer when filtered by contactNo. But I am getting an error "DataitemLink must be set" any ideas on this error please.

My code below

dataitem(Contact; "Contact")
        {
            column(ContactNo; "No.")
            {
            }



            dataitem(ContactBusinessRelations; "Contact Business Relation")
            {
                // Sets a link between FieldY of Table2 and FieldX of Table1.
                DataItemLink = "Contact No." = Contact "Company No.";
                //The dataset contains records from Table1 and Table2 where a match is found between FieldY and FieldX.
                SqlJoinType = InnerJoin;
                column(CustNo; "No.")
                {
                }
            }
            filter(Filter_ContactNo; "No.")
            {
            }
        }

Below is the error I am getting.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

Please review carefully how to use this report property.

DataItemLink Property (Reports) - Business Central | Microsoft Learn

Sell-to Customer No.=FIELD(No.)

BR

GR

Was this reply helpful? Yes No
YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, First of all, SqlJoinType cannot be used here.

Second, there is something wrong with your writing. Please refer to Microsoft standard documents or objects.

For example,

Thanks.

ZHU

Was this reply helpful? Yes No
Saurav.Dhyani 14,419 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi,

SQL Joins are not allowed to be set on report object.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No