Skip to main content

Notifications

Announcements

Announcing Category Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Adding reference contr...
Finance | Project Operations, Human Resources, ...
Answered

Adding reference control group fields to a ssrs report

(1) ShareShare
ReportReport
Posted on by CU12101739-0 29
I want to add a reference control group fields to a ssrs report
eg.Requester,orderer fields of purchTable to a ssrs report.
But I get the integer values on the report and not the string.
What is the correct way to do so?
Kindly advise
  • CU12101739-0 Profile Picture
    CU12101739-0 29 on at
    Adding reference control group fields to a ssrs report
    Thank you so much Martin Drab,I followed your steps and was able to achieve the desired output.
     
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,370 Most Valuable Professional on at
    Adding reference control group fields to a ssrs report
    The fields you're talking about are really numbers (Int64); they contain record ID from a different table (namely HcmWorker). You can use joins to fetch data from related tables. For example, if you want to show the orderer's name in the report, join PurchTable with HcmWorker over the orderer field, and HcmWorker with DirPartyTable. Then use DirPartyTable.Name field in the report.
  • CU12101739-0 Profile Picture
    CU12101739-0 29 on at
    Adding reference control group fields to a ssrs report
    Thank you Vahix but I need a way to display these int64 fields (reference fields ) as string as they are displayed in the forms.
     
  • Suggested answer
    VaHiX Profile Picture
    VaHiX 3,119 on at
    Adding reference control group fields to a ssrs report

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans