web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to write a express...

Microsoft Dynamics CRM (Archived)

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

(0) Share

Report

Report

Posted on by Suraj Jadhav

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)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Pawar Pravin 5,237 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suraj Jadhav 74 on at

Like (1)

Report

Thank You Pravin .

My problem is solved now :)

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans