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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans