Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Data Item in Report AL...
Microsoft Dynamics NAV (Archived)

Data Item in Report AL Extension 2.0

(0) ShareShare
ReportReport
Posted on by Muhammad Arif Maseed 768
How to use the Data Item Properties in the Report in Extension 2.0  Please Share with example 
The above is the report on which i am working for test learning the syntax of reports in al extension.
report 50110 TestOrderReport

{
DefaultLayout = RDLC;
dataset
{
// First Data Item
dataitem("Sales Header";"Sales Header")
{
column(No_;"No.")
{

}
// This is the 2nd Data item
dataitem("Sales Line";"Sales Line")
{
//DataItemLink= ? // how to use the property of DataItemLink.
// DataItemLinkReference= ? // how to use the property of DataItemLinkReference.
 
column(Sell_to_Customer_No_;"Sell-to Customer No.")
{

}
}
}


}

}

*This post is locked for comments

  • WilliamVDS Profile Picture
    WilliamVDS 10 on at
    RE: Data Item in Report AL Extension 2.0

    I get an error if I do this:

    DataItemLink = "Document Type"=Field("Document Type"),"Document No."=Field("No.");

  • Andrey Baludin Profile Picture
    Andrey Baludin 3,941 on at
    RE: Data Item in Report AL Extension 2.0

    Hi!

    at first you can use report snippet. Just print treport and press enter - you've got a report template.

    Secondly, use ctrl + space after dataitem to get list of possible  dataitem properties. Also you can see properties of report on screenshot. Syntax for properties the same as in CAL:

    report-example.JPG

    And for some properties you also can use snippets - tcaptionml for example (for multi language caption). With snippets and ctrl + space (available parts for current location) you can easily write AL code even if you don't know it well :)

  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Data Item in Report AL Extension 2.0

    What do you mean? Can you explain what you need?

  • Muhammad Arif Maseed Profile Picture
    Muhammad Arif Maseed 768 on at
    RE: Data Item in Report AL Extension 2.0

    Thank You Sir 

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Data Item in Report AL Extension 2.0

    Write something like:

    dataitem("Sales Header"; "Sales Header")

           {

               column("No"; "No.")

               {

               }

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

               {

                   DataItemLink = "Document Type"=FIELD("Document Type"),"Document No."=FIELD("No.");

               }

           }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans