Microsoft Dynamics AX (Archived)

SSRS > How to display numbers in an Arabic format?

(0) Share

Report

Posted on by Momochi

1,036

Hello awesome community!

I am trying to display numbers of the variables in my dataset in an Arabic format ( ١ ٢ ٣ ) .

I tried setting the property of the text box "Numeral Language" to "ar-SA" but nothing has changed.

What should I do to make them show in an Arabic format?

Any adivce would be appreciated

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Blue Wang on at

Like (0)

Report

Hi Momochi,

You can try to write code functions to convert digital formats.

Please follow this:

1.In Design view, right-click the design surface outside the border of the report and click Report Properties.

2.Add code, like this:

Public Shared Function Arabic(input As String) As String

Dim result As String = input

result = result.Replace(“1”, “?”)

result = result.Replace(“2”, “?”)

result = result.Replace(“3”, “?”)

result = result.Replace(“4”, “?”)

result = result.Replace(“5”, “?”)

result = result.Replace(“6”, “?”)

result = result.Replace(“7”, “?”)

result = result.Replace(“8”, “?”)

result = result.Replace(“9”, “?”)

result = result.Replace(“0”, “?”)

Return result

End Function

3.Go to Particular Field(text box) in report design and right click the text box,modify the Value property to use the following expression.

4.After that,deploy report and build project,then you can see the changes in the Report at Front end.

Was this reply helpful? Yes No
Momochi 1,036 on at

Like (0)

Report

Thank you Blue Wang for the detailed answer!

I followed your steps but when I deployed the report it gave me an error saying "Arabic is an invalid. InvalidIdentifier".

I'm not sure why it's not working

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Momochi,

Code.Arabic(Fields!SalesOrderInvoiceCount.Value)

This "Arabic" is the function method name.

Public Shared Function Arabic(input As String) As String.

Is it convenient to upload screenshots?

Was this reply helpful? Yes No
Momochi 1,036 on at

Like (0)

Report

Sure

Here is the expression:

Here is the error output:

Maybe custom code is not supported with AX?

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Momochi,

Sorry,My fault.

AX SSRS does not support VB code.

Was this reply helpful? Yes No
Momochi 1,036 on at

Like (0)

Report

Oh, unfortunately...

Anyway thank you for your time and help! :)

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Momochi,

I overlooked that this is the AX Forum.

You can use Data Methods.

Please refer this: [View:https://community.dynamics.com/ax/b/axcasperkamals/posts/data-methods-in-ax-reports-and-ssrs-reports:750:50]

Was this reply helpful? Yes No
Momochi 1,036 on at

Like (0)

Report

Hello Blue Wang,

I followed the video tutorials and created a datamethod and used the code you typed previously.

I used it on a simple text box that has a value of "123" , Here is the expression: DataMethod1("123")

But unfortunately when I run the report it displays as "???".

It seems that the code does not recognize the Arabic numbers.

Here is the method code:

[DataMethod(), PermissionSet(SecurityAction.Assert, Name = "FullTrust")]
public static string DataMethod1(string result)
{
result = result.Replace("1", "۱");

result = result.Replace("2", "۲");

result = result.Replace("3", "۳");

result = result.Replace("4", "٤");

result = result.Replace("5", "۵");

result = result.Replace("6", "٦");

result = result.Replace("7", "۷");

result = result.Replace("8", "۸");

result = result.Replace("9", "۹");

result = result.Replace("0", "۰");
return result;
}

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Momochi,

The format you use is C# code，So you can't put the code in directly.

If you want to use it in VB, you should use:

<DataMethod(), PermissionSet(SecurityAction.Assert, Name:="FullTrust")>

Public Shared Function GetCustomerData() As System.String

End Function

[View:https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/how-to-define-a-data-method-in-csharp:750:50]

[View:https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/how-to-define-a-data-method-in-visual-basic:750:50]

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Momochi,

I've looked at your problem description again.

You only mentioned that you changed the NumeralLanguage property, and whether you changed the NumeralVariant property.

The report needs to be redeployed after the change, otherwise it will not work.

Was this reply helpful? Yes No