Al: Property DataItemTable Reports

Created on 22 Aug 2018  路  7Comments  路  Source: microsoft/AL

Hey guys, has the property DataItemTable changed in VSC? Maybe changed to DataItemLink? I am trying to use it within my dataitem...

question

Most helpful comment

That's right!
You can use the Txt2AL converter (usually in C:\Program Files (x86)\Microsoft Dynamics NAV\110\RoleTailored Client) to convert standard reports (or some of your own) and see some sintaxis examples.
Hope it helps!

All 7 comments

Custom Sales Quote:

        dataitem("Sales header";"Sales Header")
        {
            DataItemTableView = SORTING("Document Type","No.")
                                WHERE("Document Type"=CONST(Quote));
            RequestFilterFields = "No.","Sell-to Customer No.","No. Printed";
            RequestFilterHeading = 'Sales Quote';
            column(DocType_SalesHeader;"Document Type")
...
                    dataitem("Sales Line";"Sales Line")
                    {
                        DataItemLink = "Document Type"=FIELD("Document Type"),
                                       "Document No."=FIELD("No.");
                        DataItemLinkReference = "Sales Header";
                        DataItemTableView = SORTING("Document Type","Document No.","Line No.");

Hope it helps :)

grafik

This is the error I get.

With the message?
Doubt it's needed ...

image

it's not a property anymore. The first parameter in Dataitem is the Name, the second is the DataItemTable

Ah yes, @mr-sala is correct, it's
dataitem(NAME; TABLE)

Ok, so wrong order and then I do not need the Property DataItemTable any longer?

That's right!
You can use the Txt2AL converter (usually in C:\Program Files (x86)\Microsoft Dynamics NAV\110\RoleTailored Client) to convert standard reports (or some of your own) and see some sintaxis examples.
Hope it helps!

Was this page helpful?
0 / 5 - 0 ratings