Format Values in SSRS reports

By
roopesh.valluru
-
17
7134

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

17 COMMENTS

  2. Alpha-blockers lower your blood pressure, as do PDE5 inhibitors, so combining the two drug types can again lead to a dangerous situation where your blood pressure is too low DailyMed, 2020; DailyMed, 2021 buy cialis and viagra online Patients, who appear to be non-responders to Viagra or Levitra, need to repeat a trial on an empty stomach a few different times before giving up

LEAVE A REPLY

Please enter your comment!
Please enter your name here

89 − 88 =