Lakhs separator in SSRS

Question

Post reply

Lakhs separator in SSRS

yudy.varma

Right there with Babe

Points: 755
More actions
April 12, 2011 at 10:51 pm

#234695

im using SSRS 2005,in number formating we can only do thousands separator,but i need code to separate thousands and lakhs.
ex:12345678
desired output:1,23,45,678.00

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

This should do the trick!!

=Format(Fields!Price.Value, "#,##0.00")

Raunak J

yudy.varma Right there with Babe Points: 755 More actions · Answer 2

=sum(Fields!Total_Amount.Value)

this is the expression i am using to sum the particular value.can anyone tell me how to use the below condition for the above expression...

=Format(Fields!Price.Value, "#,##0.00")

rajn.knit07 Right there with Babe Points: 714 More actions · Answer 3

write this formulain the font page of the field in ssrs

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Small question: what are lakhs?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

steveb. SSC-Forever Points: 46733 More actions · Answer 5

Koen Verbeeck (4/13/2011)
Small question: what are lakhs?

100,000

from the Indian numbering system, quite common depending on where and who you work with...

http://en.wikipedia.org/wiki/Indian_numbering_system"> http://en.wikipedia.org/wiki/Indian_numbering_system

As for the formatting if you change the language of your report to the correct language the numbering formatting should happen automatically

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 6

steveb. (4/13/2011)
Koen Verbeeck (4/13/2011)
Small question: what are lakhs?
100,000
from the Indian numbering system, quite common depending on where and who you work with...
http://en.wikipedia.org/wiki/Indian_numbering_system"> http://en.wikipedia.org/wiki/Indian_numbering_system
As for the formatting if you change the language of your report to the correct language the numbering formatting should happen automatically

I'm curious...how do you know what amount is lakh :-):-)

Raunak J

steveb. SSC-Forever Points: 46733 More actions · Answer 7

Raunak Jhawar (4/13/2011)
steveb. (4/13/2011)
Koen Verbeeck (4/13/2011)
Small question: what are lakhs?
100,000
from the Indian numbering system, quite common depending on where and who you work with...
http://en.wikipedia.org/wiki/Indian_numbering_system"> http://en.wikipedia.org/wiki/Indian_numbering_system
As for the formatting if you change the language of your report to the correct language the numbering formatting should happen automatically
I'm curious...how do you know what amount is lakh :-):-)

Me personally? i used to work with a team of Indian software developers and they would always use the Indian numbering system so i picked it up there.