SSRS Statement

Epicor ERP 10
1

Hello,

Please can someone help me with this statement? I’m trying to make it switch between information based on a field value.

=SWITCH(
	First(Fields!BuyerID_Department_c.Value, "POHeader") = "P", "+44 (0) 1872 562371", 
	First(Fields!BuyerID_Department_c.Value, "POHeader") = "E", "+44 (0) 1872 307786", 
	First(Fields!BuyerID_Department_c.Value, "POHeader") = "S", "First(Fields!PhoneNum.Value, "Company")", 
	First(Fields!BuyerID_Department_c.Value, "POHeader") = "T", "First(Fields!PhoneNum.Value, "Company")", 
True, "")

Thanks
Aaron.

2

I think you need to drop the quotations around the report fields in 3 and 4.

=SWITCH(
	First(Fields!BuyerID_Department_c.Value, "POHeader") = "P", "+44 (0) 1872 562371", 
	First(Fields!BuyerID_Department_c.Value, "POHeader") = "E", "+44 (0) 1872 307786", 
	First(Fields!BuyerID_Department_c.Value, "POHeader") = "S", First(Fields!PhoneNum.Value, "Company"), 
	First(Fields!BuyerID_Department_c.Value, "POHeader") = "T", First(Fields!PhoneNum.Value, "Company"), 
True, "")