web

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

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Displaying the value o...

Small and medium business | Business Central, N...

Answered

Displaying the value of two fields in a single column in report

(0) Share

Report

Report

Posted on by Dynamics 365 Busine...

700

Hi All,

Is it possible to display the value of two fields in a single column in report ?

On Job Card, we have a field 'Person Responsible' which is a lookup which contains the list of resources.

On report, I have to display the Resource No. with Resource Name in a single column ex. 'No.-Name'.

How can I achieve this ?

Please suggest !

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Teddy Herryanto (Th... 14,209 Super User 2025 Season 2 on at

Like (0)

Report

RE: Displaying the value of two fields in a single column in report

You can just combine them in column.

Ex: Resource."No." + Resource.Name

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

RE: Displaying the value of two fields in a single column in report

You just need to concatenate and store the value in a variable and then use that as source expression or in the dataset, you can do what teddy suggested

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Rishabh Kanaskar 2,568

#2

Sumit Singh 2,536

#3

YUN ZHU 2,015 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans