Header Data

(0) Share

Report

Posted on by jsshivalik

3,027

In a report i am using Sales Order , Sale Line Data Item. I want if sale Order has multiple Item lines then Sale Header information should be displayed only once. Sale No & Date i am displayed from Sale Order

Sale No Date Item Code Desc

1 20/04/2017 1 aaaaa

2 bbbbb

2. 21/04/2017 3 cccc

Thanks

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

Tina Menezes 2,576 on at

Like (0)

Report

RE: Header Data

Hi,

You need to create a parent group and group by sales header number. You can refer my blog to create grouping in reports.

https://tinamenezesdynamicsnavblog.wordpress.com/2017/08/05/tricks-to-perform-grouping-of-records-in-reports-of-dynamics-nav/

You can refer point no 3 and 4 to create the group.
Verified answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Header Data

You need to create by Sales No and Order Data and display those values in the group column. Check this below link for example

docs.microsoft.com/.../lesson-6-adding-grouping-and-totals-reporting-services