Align decimal positions

Satish 21 Reputation points
2021-03-25T10:14:45.647+00:00

81522-image.png

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
    2021-03-25T15:11:11.153+00:00

    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.

    --Dan

    No comments

  2. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee
    2021-03-26T05:55:22.437+00:00

    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.

    81749-screenshot-2021-03-26-135403.jpg

    Regards,

    Zoe


    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