How to link the fields from two tables while developing reports?

Business Central/NAV Developers Forum
1

Hello,

While developing a report I have used two tables “Sales Invoice Line”, and “Sales Invoice Header”. In the “Sales Invoice Line”, there is a field “Sell-to Customer No.”, and in “Sales Invoice Header” there is a field “Sale-to Customer Name”. And in my report I have taken both table, but “Sales Invoice Line” is my primary table, and another is linked to it.

So in my report I want the value for “Sale-to Customer Name”, in my report. But I am just being able to fetch the correct value of “Sell-to Customer No.”

Please provide me solution.

2

In Report there is property called DataItemLink

You can link both the table using this property

In your case you can user “No.”=“Document No” for linkage

3

Amol, Thank you for responding.

But by problem is not yet solved. I need a “Sell-to Customer Name”, in the body section of “Sales Invoice Line”.

And how can I put another field SalesPerson Name into the same body section “Sales Invoice Line”. As “Sales Invoice Line” and “Salesperson/Purchase” tables are not related (I think so), but “Sales Invoice Header” and “Salesperson/Purchase” are related, as their field “Salesperson Code” and “Code” respectively are related.

4

If you link the tables then you can directly put those fields in Sales Invoice line body from header table.

5

Thank you Amol for the support… It worked…