We help IT Professionals succeed at work.

SSRS Expression syntax with Iif Else

mburk1968
mburk1968 asked
on
301 Views
Last Modified: 2017-04-05
I have the following expression

=Iif(Parameters!ShowCost.Value="Y","Cost: " + CStr(Fields!std_cost.Value) + " ","") + Iif(Parameters!ShowPrice.Value="Y","Price: " + CStr(Fields!std_price.Value),"") + Iif(Fields!ETADate.Value="01/01/1900"," NO ETA"," ETA: " + CStr(Fields!ETADate.Value))

Open in new window


I need to change this section so that if the ShowPrice = "Margin" then Price would be NPrice
Iif(Parameters!ShowPrice.Value="Y","Price: " + CStr(Fields!std_price.Value),"") + 

Open in new window

Comment
Watch Question

Business Intelligence Developer and Analyst
CERTIFIED EXPERT
Top Expert 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION