Home  >  Blog  >   SSRS

Reporting Services Number Formatting Expressions In SSRS

Rating: 4
  
 
10285

Expressions and number formatting

As well as the standard text formatting options, you can format the style of numbers and dates. To get to these more advanced options, select the cell and then right-click on it. From the menu, choose Text Box Properties…

If you would like to become an SSRS (SQL Server Reporting Services) certified professional, then visit Mindmajix - A Global online training platform: "SSRS Training and Certification Course". This course will help you to achieve excellence in this domain.

As well as changing the visual styling of data, you can apply functions to the data as well. A useful built-in function is MonthName(). This function converts numbers from 1 to 12 into the corresponding month name, e.g. 1 becomes January, 2 becomes February, etc. When you modify data in this way, it becomes an expression.

You can open the expression editor by opening Text Box Properties (right-click on a cell) and on the General page of the dialog, look for the fx button to the right of Value and to the right of Tooltip. Click this button to open the editor. Expressions can be built up using the selections below the main window or typed in directly.

Services Number Formatting in SSRS_1

                                                          (Related Page: Adding Charts To A SSRS Report (Report Builder)

MindMajix Youtube Channel

Try it

1. In the Design view (click the Design tab at the top of the window), select the Month data cell by clicking on its edge. Be sure to select the cell and not the cell contents. You’ll know you’ve done it when the cell gets a thick border.

2. Right-click on the selected cell and choose Text Box Properties… from the menu.

3. Make sure General is selected, and then click the fx button next to the Value drop-down list. This will open the expression editor.

4. Edit the expression so that it reads
=MonthName(Fields!Month.Value)
Make sure you add both the parentheses. The MonthName function will convert numbers into month names, so where our report has a 12, it will display “December”, etc. Click OK and then OK again to return to the report design surface.

5. In the same way, open the Text Box Properties for the Total cell. Select Number from the page list on the left, and format the text box as Currency, with no decimal places and a thousand separator. Click OK.

Services Number Formatting in SSRS_2

6. Preview the report by clicking the Preview tab at the top of the window.

Frequently Asked SSRS Interview Questions & Answers

 

List of Related Microsoft Certification Courses:

 SSIS Power BI
 SSAS SQL Server
 SCCM SQL Server DBA
 SharePoint BizTalk Server
 Team Foundation Server BizTalk Server Administrator

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
SSRS TrainingMar 23 to Apr 07View Details
SSRS TrainingMar 26 to Apr 10View Details
SSRS TrainingMar 30 to Apr 14View Details
SSRS TrainingApr 02 to Apr 17View Details
Last updated: 03 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15