Align decimal positions

Satish 21 Reputation points


How to align decimal positions in SSRS Tablix.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,119 questions
{count} votes

2 answers

Sort by: Most helpful
  1. DJAdan 651 Reputation points

    Hi Kumarr,

    You have more than one problem here ...

    1. The numeric format you have chosen will never align if you have negative values because you are using parenthesis to indicate negatives.
    2. You have not specified the maximum number of values you want to the right of the decimal. Some of the values have one digit, some have two
    3. The cell alignment needs to be right justified. Some of your cells, such as 13.3 appear centered

    Fix these three issues, and you'll be all set. To do this, go into Text Box Properties for your numeric cells. Choose number to repair issue #1 and #2. Choose alignment to repair issue #3.

    I hope this helps.


    No comments

  2. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee

    Hi @Satish ,

    It's hard to meet your need to align Positive and Negative numbers in Tablix cause you have set the Negative numbers with parenthesis.

    You may use directly like -1234.0 to format the negative numbers and align it to the right.




    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October