Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / SSRS Expression OrderQ...
Finance forum

SSRS Expression OrderQty + OrderUnit #ERROR

(0) ShareShare
ReportReport
Posted on by 1,204

Hi. I simply want to display OrderQty and it's OrderUnit together side by side in a column.

So I write my expression like this : 

=Fields!OrderQty.Value + " " +Fields!OrderUnit.Value


But it's displaying #ERROR. I tried to display OrderQty only or OrderUnit only, I see that there's no missing value or anything. So I thought there could be no reason these two fields cannot be combined in a single expression.

Any clarification or suggestion would be appreciated. 

Thank You.

  • HAIRUL HAZRI Profile Picture
    HAIRUL HAZRI 1,204 on at
    RE: SSRS Expression OrderQty + OrderUnit #ERROR

    Thank you so much Sukrut. It works!

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans