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,236 Most Valuable Professional on at

Like (0)

Report

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 95,729 Super User 2025 Season 2 on at

Like (1)

Report

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,380 Super User 2025 Season 2 on at

Like (0)

Report

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