Formatting to the Currency
Hi Experts,
Requirement:
1.Format the decimal field "A_LMT" to the Currency Field as shown below.
(example: $20,000.00)
2.Format the decimal field "R_INT_ACM" with decimal Precision 2 followed by % like below
(example: 3.50%)
SQL Condition:
CASE
when ID_SYS_MTCHD like 'ACM%' AND DS_TAG_ISS_FEE = 'Limit does not match' then A_LMT
when ID_SYS_MTCHD like '%ACM' AND DS_TAG_ISS_FEE = 'Interest Rate Type does not match' then R_INT_ACM
else 'N/A'
END as ACMValue
Please provide me the expression to achieve this in SSRS 2005.
Regards,
Sreekanth.
Requirement:
1.Format the decimal field "A_LMT" to the Currency Field as shown below.
(example: $20,000.00)
2.Format the decimal field "R_INT_ACM" with decimal Precision 2 followed by % like below
(example: 3.50%)
SQL Condition:
CASE
when ID_SYS_MTCHD like 'ACM%' AND DS_TAG_ISS_FEE = 'Limit does not match' then A_LMT
when ID_SYS_MTCHD like '%ACM' AND DS_TAG_ISS_FEE = 'Interest Rate Type does not match' then R_INT_ACM
else 'N/A'
END as ACMValue
Please provide me the expression to achieve this in SSRS 2005.
Regards,
Sreekanth.
ASKER
Hi
1. Want to format on the Reporting Side.
2. A_LMT and R_INT_ACM are decimal data types
3. ACMValue sample values are $20,000.00 for A_LMT and 23.59 % for R_INT_ACM
Regards,
Sreekanth.
1. Want to format on the Reporting Side.
2. A_LMT and R_INT_ACM are decimal data types
3. ACMValue sample values are $20,000.00 for A_LMT and 23.59 % for R_INT_ACM
Regards,
Sreekanth.
Thanks for input sorry for the delay.
Here the ACMValue will return 20000.00 or 23.59 or N/A based on the case statement.
How does the case containing both the String and Decimal values combination. Is your query is in working condition?
There will not be any indication that this value is from the A_LMT or R_INT_ACM
$ and % in the values will actually will not be there in the SQL side.
How will you know that the value 20000.00 is for the A_LMT or 23.59 is for the R_INT_ACM
to format in the report?.
Here the ACMValue will return 20000.00 or 23.59 or N/A based on the case statement.
How does the case containing both the String and Decimal values combination. Is your query is in working condition?
There will not be any indication that this value is from the A_LMT or R_INT_ACM
$ and % in the values will actually will not be there in the SQL side.
How will you know that the value 20000.00 is for the A_LMT or 23.59 is for the R_INT_ACM
to format in the report?.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
good
Thanks
I have couple of questions
Did you want to do this in SQL or Reporting Side?
What are the data types in the database for the A_LMT and R_INT_ACM?
sample values for the ACMValue
If it is in Reporting Side how will you know that the value is from A_LMT or R_INT_ACM