Requirement is simple. Format the decimal field to the Currency Field as mentioned in the example below and then convert to varchar.
DB2 value of A_LMT : decimal
SSRS report value of A_LMT : varchar
when ID_SYS_MTCHD like 'ACM%' AND DS_TAG_ISS_FEE = 'Limit does not match' then CAST(A_LMT AS varchar(14))
END as ACMValue
Please correct my code above to required format and please help me with the solution.