Flow any of the ways
* Report Menu->Report properties option
* Right click on the report and choose the Report properties option
In the pop-up window, Choose the Code option in the left side.
Then in the custom code enter the following function code.
Public Function setcurrency(ByVal a As String) As String
Dim info As New System.Globalization.CultureInfo("hi-IN")
Dim s As String
s=Double.Parse(a).ToString("N2",info)
Return s
End Function
Right click on the cell where you want to change the format,
Choose the Expression option in the pop-up menu list.
Enter the following code.
Code.setcurrency(Field)
* Report Menu->Report properties option
* Right click on the report and choose the Report properties option
In the pop-up window, Choose the Code option in the left side.
Then in the custom code enter the following function code.
Public Function setcurrency(ByVal a As String) As String
Dim info As New System.Globalization.CultureInfo("hi-IN")
Dim s As String
s=Double.Parse(a).ToString("N2",info)
Return s
End Function
Right click on the cell where you want to change the format,
Choose the Expression option in the pop-up menu list.
Enter the following code.
Code.setcurrency(Field)
I used this. Works fine. But when we export it to excel it treats the field as STRING. Ideally it should treat like number. This is not happening.
ReplyDelete