Sunday, March 23, 2014

SSRS: Report Builder- how to format Number in reprot

Right clikc on value column. go to expression.

select CommonFunciton go to Text go to format number and set it.

=FormatNumber(Fields!Balance_Due.Value,2)

Balance_Due: is value column name. 2 is decimal places.

Syntax for formating the date

Format(Cdate(Fields!ColumnName_Date.Value),"MMM dd, yyyy")

=FormatPercent(Fields!ColumnName_Interest_Rate.Value/100,0)

No comments: