web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Adding reference contr...

Finance | Project Operations, Human Resources, ...

Answered

Adding reference control group fields to a ssrs report

(1) Share

Report

Report

Posted on by CU12101739-0

89

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

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Suggested answer

Vahid Ghafarpour 12,183 Super User 2025 Season 2 on at

Like (2)

Report

Did you check this article?

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/add-edit-refresh-fields-in-the-report-data-pane-report-builder-and-ssrs?view=sql-server-ver16

Was this reply helpful? Yes No
CU12101739-0 89 on at

Like (0)

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.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

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.

Was this reply helpful? Yes No
CU12101739-0 89 on at

Like (0)

Report

Thank you so much Martin Drab,I followed your steps and was able to achieve the desired output.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

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

#2

Martin Dráb 422 Most Valuable Professional

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans