Here the Data type is Decimal(data base) and is of type varchar( in report) . There are two conditions defined in the code below ( Case Stmt) for the report column "ACM" which has to be derived dynamically based on the conditions below .
I am unable to achieve this at report end as the data type is varchar and I want to achieve this only at the back end.
1st condition : "R_INT_ACM" should format and display it as % (ex: 1.50%)
2nd Condition: "A_LMT" should convert to Currency format (comma seperated) and display it as (ex: $20,000.00)
Please Note: After Converting to the required format , both the conditions below should be converted to varchar.
when ID_SYS_MTCHD like '%ACM' AND DS_TAG_ISS_FEE = 'Interest Rate Type does not match' then CAST(R_INT_ACM AS varchar(13))
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 to required format and please help me with the solution.