Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Dynamics Report Writer - Calculated Conditional Field with Three "OR" clauses

(0) ShareShare
ReportReport
Posted on by 492

I am working on a SOP Blank Invoice modification, adding a conditional calculated field. In the conditional field I have the following logic. If true it displays one set of text, if not another.

(SOP_Document_HDR_TEMP.DOC Number >= "SWI-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "SWI-9999999999" and RM_Customer_MSTR.Country Code = "CA") OR
(SOP_Document_HDR_TEMP.DOC Number >= "WEB-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "WEB-9999999999" and RM_Customer_MSTR.Country Code = "CA") OR
(SOP_Document_HDR_TEMP.DOC Number >= "INT-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "INT-9999999999" and RM_Customer_MSTR.Country Code = "CA")

The conditional works when evaluating the first or second clause, but the third clause with the "INT-" invoice does not. The supporting data and syntax is valid. My question is does Report Writer support the three "OR" options? Please advise. Looking for some feedback and advice. Thank you.

Categories:
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    13,982 Most Valuable Professional on at
    RE: Dynamics Report Writer - Calculated Conditional Field with Three "OR" clauses

    It should be able to handle multiple OR clauses.

    But you could use multiple calculated fields to simplify the final 4th calculated field.

    You could also use GP Power Tools to create custom Report Writer functions with any logic you desire in them.

    Regards

    David 

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans