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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to write multiple ...
Microsoft Dynamics CRM (Archived)

How to write multiple AND and OR condition in SSRS Expressions

(0) ShareShare
ReportReport
Posted on by Suraj Jadhav 74

Hello,

One of my requirement is as below

IF    Fields!ParameterDate.Value = Fields!ModifiedOn.Value AND

Fields!statuscodeValue.Value = 1 OR Fields!statuscodeValue.Value = 2,

Then 

Count(Fields!ticketno.Value)

How do i write expression in ssrs report . Please help me with this

Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Kokulan Profile Picture
    Kokulan 18,054 on at

    Have tried using Parenthesis

    IF ((Fields!ParameterDate.Value = Fields!ModifiedOn.Value AND

    Fields!statuscodeValue.Value = 1) OR Fields!statuscodeValue.Value = 2),

    Then 

    Count(Fields!ticketno.Value)

  • Suggested answer
    Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at

    IIF((Fields!ParameterDate.Value = Fields!ModifiedOn.Value) AND ((Fields!statuscodeValue.Value = 1) OR (Fields!statuscodeValue.Value = 2)),Count(Fields!ticketno.Value),0)

  • Suggested answer
    Saddamk206 Profile Picture
    Saddamk206 777 on at

    Hope this expression will work for you

    IIF((Fields!ParameterDate.Value = Fields!ModifiedOn.Value) AND (Fields!statuscodeValue.Value = 1 OR Fields!statuscodeValue.Value = 2),Count(Fields!ticketno.Value),0)

  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    You can also use AndAlso instead of And, and ORELSE instead of OR. These short-circuit the logic, which is useful if any of the fields contain a null value, which might otherwise cause the expression to fail

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans