change the decimal separator and thousand separator dynamically in crystal report in web application [Resolved]

Posted by Preejo under ASP.NET on 2/25/2012 | Points: 10 | Views : 4046 | Status : [Member] | Replies : 3
Hi friends,
I am using C#,ASP.NET,.NET FRAMEWORK 2.,crystal reports 9
I have a web application .
how to change the decimal separator and thousand separator dynamically in crystal report in web application?


Thanks in advance
george




Responses

Posted by: Preejo on: 2/29/2012 [Member] Starter | Points: 25

Up
0
Down

Resolved
Hi friends,

The solution is like this.

1) create formula field
2) right click on the field in crystal report and select format object ->number tab -> customize button
3) right of decimal separator and thousand separato textbox , a
button is present .
4) Apply formula field to use condition for display decimal/thousand separator


Thanks
preejo

Preejo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Blessyjees on: 2/27/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi,

Can you specify your format.

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Preejo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Preejo on: 2/27/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Blessy,

number formats are 1.123,45 or 1,123.45
The possible thousand separators are , or .
The possible decimal separators are . or ,
Our purpose is to create a single crystal report suitable for EU( decimal separator=, and thousand separator =.) or UK( decimal separator=. and thousand separator =,) number formats?

George


Preejo, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response