SSRS report does not have Accounting-formatting
feature like MS Excel have. But some banking and Financial Client asks
Accounting Formatting to numbers in SSRS, here is the solution for this
Image shows Differences of accounting right align currency format
To achieve this you need to Tweak Expression as shown below, give
space after 0 for accounting format and after – to align no data in same
format. you can change this expression as per your Need, Space is the Solution to get Accounting Format.
#,0;(#,0);'-'
#,0
;(#,0);'- '
Please look into below image
Thank you, Please give your reply, question, Feedback and any additional Tweaks
