News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Automation Report Test...

Small and medium business | Business Central, N...

Suggested answer

Automation Report Tests - iterate through child dataitem

(0) Share

Report

Report

Posted on by Maxim Rylev

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.

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 85,845 Super User 2025 Season 1 on at

Like (0)

Report

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 1,029 Moderator on at

Like (0)

Report

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.

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans