CODEWITHSUNDEEP
reporting-serviceslocalizationreportviewerrdlcrdl
Raef Tharwat
Raef Tharwat

Reputation: 31

Format number Rdlc report

i need to show numbers 1 2 3 in Arabic letters

i write in text box expression this statement

=FormatNumber(Fields!Size.Value,1,-2,-2,-2)

but i don't know it's parameter and which parameter can show numbers in Arabic format

MANY THANKS

Upvotes: 3

Views: 6496

Answers (3)

Ahmed Gad
Ahmed Gad

Reputation: 11

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

Use it for arabic Numbers =Code.Arabic(Fields!OrderID.Value) =Code.Arabic(FieldName)

Upvotes: 1

Alireza Parsa
Alireza Parsa

Reputation: 11

You can write function in code and use that

enter image description here

Public Shared Function farsi(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

Usage:

=Code.farsi(1111.555)

Upvotes: 1

George Botros
George Botros

Reputation: 4401

set report language to your local language (ar-EG) in the textbox properties set NumeralVariant to 3

references

similar problem

NumeralVariant

limitations

1- will not work for strings containing numbers

2- will not work for dates

work around limitation with bad performance i guess

you can replace any english number with arabic number using Replace method in any string that may contain numbers your expression will be some thing like this

=Replace(Replace(Replace(Fields!FieldName.Value,"0","۰"),"1","۱"),"2","۲")

complete expression to 9

Upvotes: 3

Related Questions