Ssrs report design expression with Or condition .

(1) Share

Report

Posted on by Dineshkarlekar

1,836

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/

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

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 .

Was this reply helpful? Yes No
Verified answer

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Ssrs report design expression with Or condition .

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Ssrs report design expression with Or condition .

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates