SSRS formatting numbers

[Kanan]

I am making a report where i have to put numbers for showing profit & loss... I am using SQL Server Reporting Services(SSRS). For example : 224308.81 Does anyone know how to do it..???? Please Help....!

[Praetor]

I have made a code for it just put it in the CODE Window... For going into the ODE Windows Firstly go to REPORT then go to REPORT PROPERTIES & then go to CODE Window....!

ADD this code there :

Public Function FormatIndian(ByVal Amount As decimal) As String  
Dim strAmount As String
Dim strGrpsArr() As String
Dim lngPos As Long
Dim lngIndex As Long

   strAmount = Format$(Amount, "#")
   If Len(strAmount) < 4 Then
      FormatIndian = strAmount
   Else
      lngIndex = (Len(strAmount) - 2) \ 2
      ReDim strGrpsArr(lngIndex)
     
      strGrpsArr(lngIndex) = Mid$(strAmount, Len(strAmount) - 2)
     
      lngPos = Len(strAmount) - 4:  lngIndex = lngIndex - 1
      Do
         strGrpsArr(lngIndex) = Mid$(strAmount, lngPos, 2)
         lngPos = lngPos - 2:       lngIndex = lngIndex - 1
         If lngPos = 0 Then strGrpsArr(0) = Left$(strAmount, 1)
      Loop Until lngPos <= 0
     
      FormatIndian = Join(strGrpsArr, ",")
      Erase strGrpsArr
   End If
End Function

After that you need to add the following expression in the text box :

=code.FormatIndian(Fields!AMOUNT.Value)

[kelfro]

I think firstly you need to know how to tell the formatting for negative numbers and positive numbers. The formula becomes to be #,##0;(#,##0). The Main key here is semicolon that differentiate positive from negative. It is that the left is positive & right is negative.

[Zecho]

Try this which may help you..... Just try to put the following Expression in Text box :

=IIF(Rownumber(Nothing) = 1, N, P2)

See if it works for you....!