Accounting Format for numbers in SSRS report

    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