How to Format TextBox Value in SSRS

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.

Ebook Download
View all
Learn
View all