Here I am going to discuss one of features of SSRS. Here we are going to see how to formatting number and date textbox value in SSRS and we can also add own custom formatting of any textbox value. Let’s starts our tour. We are going to discuss about below features.
![]()
Figure 1: Number
In above window we can see multiple options for date and number formatting.
Using these options we can set format of number,mony, date,time.
Here I am showing you how to format date value in particular format.
Go to TextBox which you want to format and then right click over there then select TextBox properties.
![]()
Figure 2: TextBox properties
Then go to Number tab of this window then select date option from category.
![]()
Figure 3: Category
we go to date option and select date format.
![]()
Figure 4: Select Date
After that Press OK.
Now we can see output look like this.
![]()
Figure 5: output
As like above we can set format for number and money from here.
![]()
Figure 6: Set Number
If in any case need to apply user defined formatting on Textbox value then we can also add custom formatting over there.
We can write expression for custom format.
![]()
Figure 7: Custom Format
Thanks for reading.