Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Automation Report Tests - iterate through child dataitem

Posted on by 75

Hi! I want to test report with parent (for example Sales Header) and child (Sales Lines) dataitems.

How can I iterate through Sales Lines in this situation? Using row functions I only get one row - for parent (header) dataitem.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 70,124 Super User 2024 Season 2 on at
    RE: Automation Report Tests - iterate through child dataitem

    Hi, if you are talking about Automation Testing Reports, hope the following helps.

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-testing-reports

       

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Automation Report Tests - iterate through child dataitem

    If you are wondering how you create such a report you have to define two dataitens and use the

    data item link to link the saleas head and sales line in this case.

    learn.microsoft.com/.../devenv-dataitemlink-reports-property

    You can also look here for an example where jobs are used.

    community.dynamics.com/.../report-data-item-link

    You also find lots of standard reports using the same methodology.

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans