web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Electronic Reporting -...
Finance | Project Operations, Human Resources, ...
Suggested answer

Electronic Reporting - join two table for finding a data

(0) ShareShare
ReportReport
Posted on by Giorgio S 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

I have the same question (0)
  • Suggested answer
    Svetlana Kosheleva Profile Picture
    Svetlana Kosheleva on at
    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!

  • 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())
  • 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

  • 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 667 Most Valuable Professional

#2
CU05031448-0 Profile Picture

CU05031448-0 584

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 554 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans