Home Forums SQL Server 2005 Business Intelligence SSRS Text Box Properties: 2008 RE: SSRS Text Box Properties: 2008

  • October 29, 2012 at 2:05 pm

    #1553899

    niha.736 (10/29/2012)

    problem has moved a bit forward , But strucked over a little change

    =IIF(CInt(ReportItems!Sales38.Value) > 99999, ReportItems!Sales38.Value, FormatNumber(CDbl(ReportItems!Sales38.Value),"N2"))

    this is the expression i have written. with help of this am getting values with decimal values

    like 76585.23 for some rows 89096.2

    Problem is: i need to get 2 decimal points after " . "

    can anybody suggest something.

    Would FormatCurrency() work better for you than FormatNumber()?

    Or something like:

    =Format(Fields!Sales38.Value, "#,##0.00")

    Good luck,

    Rob