Microsoft Dynamics AX (Archived)

SSRS Expression Switch Statement

(0) Share

Report

Posted on by Muhammad_Ali

353

Hi -

I need to write an Expression in Visual Studio 2013 containing the Logic as written below.

IF (WFRegionalID == "USA" && WFDisplayPrintCOA == 1)
{

print ("[XX] Certificate of Analysis");

}

else

{

print ("[ ] Certificate of Analysis")

}

The problem Im facing is that I cant seem to come up with the code which compares two values like (WFRegionalID == "USA" && WFDisplayPrintCOA == 1) .

Can you please suggest me how I can write this logic in Visual Studio Expression ?

As of now I have this line of code in my expression and it works I just need to add an extra flag which checks for the value of WFRegionalID along with WFDisplayPrintCOA at the same time.

=Switch(Fields!WFdisplayPrintCOA.Value = 1 , "[XX] Certificate of Analysis", 1=1, "[ ] Certificate of Analysis")

Thanks

*This post is locked for comments

I have the same question (0)

All responses (24)

Answers (2)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report

Hi Muhammad_Ali,

Try =iif((Fields!WFdisplayPrintCOA.Value = 1) AND (WFRegionalID = "USA"), "[ ] Certificate of Analysis", "")

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

you can write both if conditions, one in the first line click enter and the second in the next line, both logic will execute in the order you set it.

or you can use the switch statement.

Are you using the visibility condition?

Was this reply helpful? Yes No
Muhammad_Ali 353 on at

Like (0)

Report

thank you for the reply ievgen but unfortunately your line of code is not getting the correct results. It is always evaluated to this "".

The code I have written is this

=IIf(Fields!WFdisplayPrintCOA.Value = 1 AND Fields!CountryRegionId.Value = "USA", "[XX] Certificate of Analysis", "[] Certificate of Analysis")

Was this reply helpful? Yes No
Muhammad_Ali 353 on at

Like (0)

Report

Hi Tatiana Garcia Ramos -

No I'm not using the visibility condition.

I was using switch originally but I dont know how to compare two expressions in one switch condition. If we can do this with IFF its fine but I need to know the syntax.

Thanks

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

It can't evaluate to "" because that's an "if" statement it should return either [XX] Certificate of Analysis or [] Certificate of Analysis, are you sure that there is no syntax error ?

Was this reply helpful? Yes No
Muhammad_Ali 353 on at

Like (0)

Report

ievgen sorry typo on my part. It is always evaluated to [] Certificate of Analysis.

No syntax error. I have pasted the exact code from the expression box.

Was this reply helpful? Yes No
Muhammad_Ali 353 on at

Like (0)

Report

=IIf(Fields!WFdisplayPrintCOA.Value = 1 AND Fields!CountryRegionId.Value = "USA", "[XX] Certificate of Analysis", "[] Certificate of Analysis")

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

that means that "Fields!WFdisplayPrintCOA.Value = 1 AND Fields!CountryRegionId.Value = "USA"" is false. Did you check that WFdisplayPrintCOA is 1 and CountryRegionId is "USA" ? It's easy to do, just put them into another column.

Was this reply helpful? Yes No
Muhammad_Ali 353 on at

Like (0)

Report

Ievgen Yes I made sure that both the fields have the correct value. But still for some reason the If statement is always evaluated to "[] Certificate of Analysis".

what do you mean put them into another column ? You mean add a new column and use the same code to see if it works ?

Thank You

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

maybe Fields!WFdisplayPrintCOA.Value is string not int, try Fields!WFdisplayPrintCOA.Value = "1"

Was this reply helpful? Yes No

Community site session details

SSRS Expression Switch Statement

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

SSRS Expression Switch Statement

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 > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates