Ssrs report design expression with Or condition .

(1) Share

Report

Posted on by Dineshkarlekar

1,479

I am working on report which is having the Expression in text box which makes the text visible on when the report opens on specific menu item i want to add my condition in or expression how can i achive this in ssrs report , can plz anyone one guide me on this .

this is the text box expression ,

//=iif(Parameters!POHeader_strMenuName.Value=/IM_VendPurchaseOrder/,/Note: this purchase order is approved electronically by Bahra Electric management and does not require any signature/ & Vbcrlf & Vbcrlf & /Best regards,/ & Vbcrlf & Vbcrlf & /Bahra Electric - Procurement Department/,//)

this is the expression i need to add in or case

//=iif(Parameters!DTPurchStatus =1,true,false ,/Note: this purchase order is approved electronically by Bahra Electric management and does not require any signature/ & Vbcrlf & Vbcrlf & /Best regards,/ & Vbcrlf & Vbcrlf & /Bahra Electric - Procurement Department/,//)

but i am getting error if i put both expression using /OR/

All responses (3)

Answers (1)

Verified answer

Layan Jwei 7,727 Super User 2025 Season 1 on at

Like (1)

Report

Ssrs report design expression with Or condition .

Hi Dinesh,

You didn't share the current expression that you wrote which errors so that we amend it for you. Can you please share it? Or please type what is the exact requirement, If sth, then you need this and this Else you need that (as didn't quite understand from your question)

Did you try sth similar to this? (of course replace it with your field values)

=IIF(Parameters!Name.Value="Value1" OR Parameters!Name.Value="Value2", "Print what you would like to see when condition is met", "")

Thanks,
Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Dineshkarlekar 1,479 on at

Like (0)

Report

Ssrs report design expression with Or condition .

but how can i enter these lines /Note: this purchase order is approved electronically by Bahra Electric management and does not require any signature/ & Vbcrlf & Vbcrlf & /Best regards,/ & Vbcrlf & Vbcrlf & /Bahra Electric - Procurement Department/,//) that is still my problem .
Suggested answer

Layan Jwei 7,727 Super User 2025 Season 1 on at

Like (1)

Report

Ssrs report design expression with Or condition .

Hi Dinesh

Can you please show us the full expression you wrote including the OR to know what the issue is.

Maybe also check this link to see how to do an OR expression

https://debug.to/2284/how-to-use-multiple-and-or-in-iif-expression-in-ssrs

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Community site session details

Ssrs report design expression with Or condition .

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Ssrs report design expression with Or condition .

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates