Search code examples
reporting-servicesdecimaldecimal-point

Showing percentage in SSRS report

I know that percentage in SSRS report is given by 0% (for zero decimal places) or 0.00% (for 2 decimal places) etc..

My specific issue is that I want to show, say 90 as 90%, and 34.45 as 34.45%.

Please note the use of decimal places in both cases. Is there a way to define an optional decimal places for percentage?

Solution

  • I would use an Expression to set the Format property, something like:

    =Iif ( Me.Value = Floor ( Me.Value ) , "0%" , "0.00%" )