Format Values in SSRS reports

By
roopesh.valluru
-
60
21750

Friends,

Most frequently you will be coming across the following formatting requirement.

  • Round the values to TWO decimals
  • Round the values to TWO decimals currency.

In this post I am gonna show a simple example to demonstrate the same. I created a matrix report with Sales Amount and Tax Amounts and PFB the preview of the same.

If you see the values in the above screenshot, it has more than two decimals. Now I am gonna FORMAT the sales amount to TWO decimals and tax amount to TWO decimal CURRENCY.

There are many ways to acheive the same and let me explain the most commonly used one here i.e by using FORMAT property of the text box in SSRS report.

For TWO decimals you need to set the FORMAT property value of the text box to “#,##0.00” as shown below.

For TWO decimal CURRENCY you need to set the FORMAT property value of the text box to “$#,##0.00” as shown below.

Now preview the report and you can see the values in new formats as shown below.

Rock it guys !!

Regards,
Roopesh Babu V

 

RELATED ARTICLESMORE FROM AUTHOR

60 COMMENTS

  6. An endoultasound is carried out in the same way as a gastroscopy, but with the addition of a special ultrasound probe on the tip of the gastroscope.
    amounts with discountsExperience health benefits when you buy can you buy generic vardenafil in us to manage symptoms
    The suggestion comes from the authors of a new analysis to combine data from two large phase 3 trials that has been published in The Lancet Oncology.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

+ 49 = fifty six