web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / If value is yes print ...
Finance | Project Operations, Human Resources, ...
Answered

If value is yes print "*" if no print blank in SSRS report in D365FO.

(0) ShareShare
ReportReport
Posted on by CU21091228-0 230
Hi Team,
 
I am creating one SSRS report here i am having on Enum Test field which value is NoYes.
 
If 'Yes' value is set  '*' will get output in SSRS report.
If 'No' value is set blank should output in SSRS report.
 
Please let me know how to achieve this.
I have the same question (0)
  • Verified answer
    Layan Jwei Profile Picture
    Layan Jwei 8,060 Super User 2025 Season 2 on at
    If value is yes print "*" if no print blank in SSRS report in D365FO.
    Hi User,
     
    I didn't try it myself but maybe try to write this expression
     
    =IIf(Fields!EnumTest.Value = "Yes", "*", "")
     
    Please let me know if it works with you
     
     
    Thanks,
    Layan Jwei
  • Mohit Rampal Profile Picture
    Mohit Rampal 12,563 Moderator on at
    If value is yes print "*" if no print blank in SSRS report in D365FO.
    Hi, In addition, if required, you can refer to this article and use expression provided by Layan in a textbox in ssrs report design. That expression should work.
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 588 Most Valuable Professional

#3
Sumit Singh Profile Picture

Sumit Singh 544

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans