Indian number format in Telerik report

[Kunal Bagga]

Hi,
In my report cultureInfo will differ on different conditions. Regards of all the other culture,I am facing little problem in implementing the Indian culture format. Especially during the number format. 
If I set the culture to en-IN => it works fine but it is in the format of ###,##,###.## which I don't need. So I implemented with hi-IN . Though the number format is fine the numbers are not displayed as normal numbers (they are displayed as numerals of the current culture). Please find the attached picture of the numbers displayed for this. 

Can you help me in implementing the culture ie the number format has to be ##,##,##,###.## and has to be displayed in normal numbers. 

[Hinata]

Hi Kunal,

Is it possible for you to share the actual report definition?

[Kunal Bagga]

Hi Hardik, 
You could duplicate the issue in any telerik report. I am using HTML5 report (Its best for you to use that also).

In the report please follow the conditions below
  * Add a table which shows number in any column. (Please have the numbers to be at-least 9 digits)
  * You can change the Culture of the report to en-IN , hi-IN
  * While using hi-IN you could see the difference in the way numbers are displayed. 

My requirement is I wanted display numbers in 00,00,00,000 format. 
If I use "en-IN" format, I am getting  0,000,00,000 format
but when "hi-IN" format, I am getting the correct format but numbers are displayed differently. 

May I know how can I achieve this? Please note that the culture of the report varies differently based on the project. If it is Indian project we will change the culture to this but if it is Singapore/ Malaysian project we will display the numbers accordingly. So we cannot hard code the format here.

Hope you understand. 

[Hinata]

Hi Kunal,

The en-IN culture currency format is working as expected on my PC. Check this screenshot.

[Kunal Bagga]

Mine is displaying in this format( Find the attached pic). What problem this could be?

[Stef]

Hello Kunal,

If you are checking the results on preview in Visual Studio, the report will be displayed with the culture settings for Visual Studio. To get the actual result you need to create a project with a viewer and change the current thread culture. For example check the attached demo project (the culture can be changed in the Program.cs file).
Additional details about globalization are available in the Report Globalization help article.

Having this into account, when you specify the CultureInfo, you can provide custom format for numbers as well.


I hope the above information helps you.

Regards,
Stef
Telerik

 

 

[Kunal Bagga]

Hi Stef, 
Thanks for your reply. 

I have tried your solution, but still I couldn't get a valid solution. I have attached the different methods that I tried for this. 

reportViewer.jpg => this is how I implement the viewer for this report. 
aspxLoad.jpg => I tried the threading during the load page. This shows how I use the code.
reportBackEnd => I tried the threading in needDataSource. This I tried with and without threading in main aspx page. 
result => the result I get.

Thanks for processing the reply. Would be good if you get process this request fast and give us a reply asap 

[Kunal Bagga]

Hi Stef, 
Please ignore the last post. I have found the solution for this. I used the following code in the NeedDataSource event and it works fine.

CultureInfo myCL = new CultureInfo("en-IN", false);
                        CultureInfo myCIclone = (CultureInfo)myCL.Clone();
                        NumberFormatInfo numberFormat = myCIclone.NumberFormat;
                        int[] mySize = { 3, 2 };
                        numberFormat.NumberGroupSizes = mySize;
                        numberFormat.CurrencyGroupSizes = mySize;
                        this.Culture = myCIclone;

Thanks for your time. 

[hemanth]

In search of an answer to my post in stack overflow, I reached here. It seems to be a problem with server version.

http://stackoverflow.com/questions/42202771/numbergroupsizes-for-en-in-culture-in-windows-server-2012-is-wrong