Search code examples
reporting-servicesreportingssrs-2012bids

How to write format expression for 100k separator in SSRS?

I have searched on google and nothing found about lac (Indian numbering system) separator in SSRS report and I am familiar with thousand separators, I am using visual studio 2012.

for ex: input 1111500000, output like this: 11115,00,000.

I need 1000 separator and 100k separators both in same format expression.

Solution

  • Following should work for you:

    In the format box

    enter image description here

    use

    ##\,##\,##0;

    And this will format the number as per your requirements (i.e. 11115,00,000).