RE: Custom Code in SSRS Reports for 365 Online
This is what I have in my Custom Code:
Function GetPurchaseItemLine_itemRefForVendorPOs(JobType As String, Service As String) As String
If Service.Contains("Back Translate") And JobType = "Life Sciences" Then Return "Back Translate - LST (P)"
If Service.Contains("Back Translate") And JobType = "Linguistic Validation" Then Return "Back Translate - LV (P)"
If Service.Contains("Edit") And JobType = "Life Sciences" Then Return "Edit - LST (P)"
If Service.Contains("Edit") And JobType = "Linguistic Validation" Then Return "Edit - LV (P)"
If Service.Contains("Interpret") And JobType = "Life Sciences" Then Return "Interpret - LST (P)"
If Service.Contains("Interpret") And JobType = "Linguistic Validation" Then Return "Interpret - LV (P)"
If Service.Contains("Linguistic Proofread") And JobType = "Life Sciences" Then Return "Linguistic Proofread - LST (P)"
If Service.Contains("Linguistic Proofread") And JobType = "Linguistic Validation" Then Return "Linguistic Proofread - LV (P)"
If Service.Contains("Rekey") And JobType = "Life Sciences" Then Return "Rekey - LST (P)"
Return Service
End Function
Ad I am calling this in the Expression as:
=Code.GetPurchaseItemLine_itemRefForVendorPOs(Fields!cti_jobtype.Value,Fields!serviceid.Value)