Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

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

Posted on by 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 !

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,640 on at
    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

  • Verified answer
    TeddyH Profile Picture
    TeddyH 12,861 Moderator on at
    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

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans