Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Adding reference field...
Finance forum
Unanswered

Adding reference fields from the purch table to the ssrs report

(1) ShareShare
ReportReport
Posted on by CU12101739-0 10
The requester and orderer fields are both reference control fields from purch table.
If I am able to add and show the orderer field,I am not able to display the requester field as the report goes blank
I am using the name from DirPartyTable from datasources
 
Can anyone plz suggest the correct way to achieve this Thanks
Categories:
Development / Customization / SDK
  • Olayinka Komolafe Profile Picture
    Olayinka Komolafe 16 on at
    Adding reference fields from the purch table to the ssrs report
    Hi
     
    You might need to be explicit and clear with the problem.

    What exactly are you trying to achieve and what issue are you facing?
     
    If you say you have blank data, can we see your query?
  • Martin Dráb Profile Picture
    Martin Dráb 228,815 Most Valuable Professional on at
    Adding reference fields from the purch table to the ssrs report
    First of all, don't try to test everything at once - it's slow and it doesn't tell you which part is wrong.
     
    For example, check if your query returns the right data. If not, there is no point in using it an RDP class and running the report.
     
    If the query looks fine, your next step is debugging the RDP class and checking whether it inserts the right data to temporary tables.
     
    Testing the report design would be the last step, but you already know that your problem is with the data preparation, therefore it's not really relevant in your case.
     
    Back to your query. Unfortunately, you haven't told us much about it. First of all, are you using outer joins for HcmWorker data sources? If not, it's a problem, because then your query returns just orders with both WorkerPurchPlacer and Requester filled in, which likely isn't what you want.

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

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

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…

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,815 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans