=IIF(Fields!SpParameterValues.Value <> "", SWITCH( Fields!Id.Value = 2," Occupied Column: " + (Split(Fields!SpParameterValues.Value,"|").GetValue(0))+" "+(Split(Fields!SpParameterValues.Value,"|").GetValue(1))+" Value " + (Split(Fields!SpParameterValues.Value,"|").GetValue(2))+" "+(Split(Fields!SpParameterValues.Value,"|").GetValue(3))+ VBCRLF + " Occupied Unit Column: "+ (Split(Fields!SpParameterValues.Value,"|").GetValue(4)), Fields!Id.Value = 1," Vaccant unit Column: " + (Split(Fields!SpParameterValues.Value,"|").GetValue(0))+" "+(Split(Fields!SpParameterValues.Value,"|").GetValue(1))+" Value " + (Split(Fields!SpParameterValues.Value,"|").GetValue(2))+" "+(Split(Fields!SpParameterValues.Value,"|").GetValue(3))+ VBCRLF +" Charge Column: "+ (Split(Fields!SpParameterValues.Value,"|").GetValue(4))+" "+(Split(Fields!SpParameterValues.Value,"|").GetValue(5))+" Value "+ (Split(Fields!SpParameterValues.Value,"|").GetValue(6)), True,"" ), Fields!SpParameterValues.Value)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)