Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

How to get the date from 2 tables in a report

Posted on by 10

Hello everyone,

Can someone please help me with this problem. I'm kind new to NAV.

So: I've created a report for medical certificate. The tables are "Employee HR" and "Archive Disease V13". The report works, all good, but now the company wants when they run the report for one employee to appear also the date from current month or the last month. As i understand from the company, there is another table called "Disease HR", which got the same structure as "Archive Disease V13", but here are the latest information stored. I tried to connect the new table to the report and dataitemlinked to the employee hr, but when i run the report it shows me this and appears (-) which was not before:

4628.PNG

Also from the "Disease HR:, for the same employee this the structure and as you can see, last 2 dates didn't appear in the report:

5736.PNG

So, my question is: How can i retrieve the last 2 dates from "Disease HR" to appear on the report and get rid of (-).

Thank you

  • Suggested answer
    THE Italian Profile Picture
    THE Italian on at
    RE: How to get the date from 2 tables in a report

    I think you must use 2 data items

    Data Item --> table 1

    Data Item --> table 2

    Then you will have all your records in the order that you are in need of.

    Then you must add a conditional formatting in the value of the textbox with something like IIF(table1.valueX = "",datefromtable2, datefromtable1)

    In this way, it will print dates from table1 first and then from table2

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,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans