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 :
Microsoft Dynamics CRM (Archived)

How to write a expression with multiple if conditions in RDL(SSRS) Reports for CRM Dynamics Online

(0) ShareShare
ReportReport
Posted on by 74

Hello ,

I want expression for below scenario in RDL(SSRS) reporting Expressions

if Amount="5000.00" show "ABC"

if Amount="2000.00" show "XYZ"

if Amount="1000.00" show "pqr"

otherwise show "AAA" 

How i write expression with  multiple conditions?

Please help me with this. Thank You.

*This post is locked for comments

I have the same question (0)
  • Suraj Jadhav Profile Picture
    74 on at
    RE: How to write a expression with multiple if conditions in RDL(SSRS) Reports for CRM Dynamics Online

    Thank You Pravin .

    My problem is solved now :)

  • Verified answer
    Pawar Pravin  Profile Picture
    5,237 on at
    RE: How to write a expression with multiple if conditions in RDL(SSRS) Reports for CRM Dynamics Online

    Hi Suraj,

    You can use if else lookp inside tablix/matrix.

    Please do refer following url , it could hellp you.

    social.msdn.microsoft.com/.../multiple-iif-in-an-expression-in-ssrs

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans