Unanswered

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:

Development

All responses (3)

Answers (0)

Saurav.Dhyani 14,450 User Group Leader on at

Like (0)

Report

Data Item link AL

Hi,

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

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube
YUN ZHU 63,522 Super User on at

Like (1)

Report

Data Item link AL

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
gdrenteria 4,646 Super User on at

Like (0)

Report

Data Item link AL

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