Skip to main content

Notifications

Dynamics 365 Community / Forums / Human Resources forum / Electronic Reporting -...
Human Resources forum
Suggested answer

Electronic Reporting - join two table for finding a data

Posted on by 15

Hi Everybody,

I am new in using Electronic reporting.

I have a problem for retrieving some data to generate an xls file.

I have to data sources:

HcmEmployeeEntity --->tab1

HcmPersonIdentificationNumber --->tab2

From the tab2 I have to export all information related to PersonalNumber(fiscalCode), full name and e-mail, I can find this information easily with the predefined relations with people table.

From tab1 I have to extract for each row coming from tab2, the related employment start date.

There is no predefined direct relation between the 2 tables but the relation with people table can help for my purpose, now my question is:

How can I collect the information I need?

For me this is a normal lookup between 2 datasource but I can't find the right way for doing it.

Does anyone help me

Regards

Giorgio

  • Timo Tenni Profile Picture
    Timo Tenni on at
    RE: Electronic Reporting - join two table for finding a data

    Thank you Giorgio for the update and sharing the you resolved the issue.

  • Giorgio S Profile Picture
    Giorgio S 15 on at
    RE: Electronic Reporting - join two table for finding a data

    Hi Everebody, 

    For your information I solved the problem using the relations inherited directly by the model.

    Thanks

    Girogio

  • Suggested answer
    Timo Tenni Profile Picture
    Timo Tenni on at
    RE: Electronic Reporting - join two table for finding a data

    For lookup data in other table we can use:

    1. FILTER function
    2. JOIN datasource
    3. Call application methods (like ::find())
  • Suggested answer
    RE: Electronic Reporting - join two table for finding a data

    Hi Giorgio,

    Could you please specify what are you trying to achieve by using Electronic Reporting feature for HR data?

    Electronic reporting is mainly used for financial reporting purposes.

    If you need to export HR data from the system you can use Data Management feature, which is design for export/import data in D365.

    Here you can find more info: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities-data-packages

    If you have any questions or comments, please let know. Thank you in advance!

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans