Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs

Format Numbers in SSRS Report

by suresh

In this article, we will show you the step by step approach to format Numbers in SSRS Report. Or, How to Format the Numeric values or Numbers present in a Textbox in SQL Server Reporting Services or SSRS with an example.

To explain the available Numeric Format options, We are going to use the below-shown report. Please refer SSRS Table Report article to understand the Shared Data Source, and Dataset we used for this SSRS report. It was a normal report with Product Name, Color, Sales, and Tax Amount columns.

Format Numbers in SSRS 2014

From the above screenshot, the numeric values present in Sales Amount and Tax Amount columns are not attractive to impress the end-user. Too many numbers after the decimal and no currency symbol.

Formatting Numbers in SSRS

To Format Numbers in SSRS Report, Please select the Textbox containing Numeric values.

In this SSRS Formatting Numbers example, Select Sales Amount Textbox of the report, and Right-click on it will open the context menu. Please select the Text Box Properties.. option from it

Format Numbers in SSRS 1

Once we click on the Text Box Properties.. option, a new Text box Properties window will open. Please select the Number tab .

Format Numbers in SSRS 2

Properties to Format Number in SSRS

To format a number in SSRS, Please select the Numbers Category from the available list.

  • To remove those extra numbers from the decimal place, Select the Decimal Place property and change the value to 2.
  • Use 1000 separator(,): If you want to separate 1000 with a comma then Select this option
Format Numbers in SSRS 4

Click ok to finish Formatting the Numeric value of the Sales Amount text box. Let us preview the SSRS Format Numbers report

Format Numbers in SSRS 5

Now, let us format the Numeric values in Tax Amount

Format Currency in SSRS

Please select the Currency Category from the available list. To change the currency, Please select the required currency from the provided list

Format Numbers in SSRS 6

We selected the United States Dollar for this example

Format Numbers in SSRS 7

Click ok to finish Formatting the numbers in Sales and Tax Amount columns. Let us see the SSRS Format currency preview

Format Numbers in SSRS 8

If you observe the above screenshot, Numeric data in Sales Amount & Tax Amount columns looks attractive and more meaningful

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy