question

kumarrr avatar image
0 Votes"
kumarrr asked Zoehui-MSFT commented

Align decimal positions


81522-image.png

How to align decimal positions in SSRS Tablix.


sql-server-reporting-services
image.png (3.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Not clear what you mean here? What exactly do you want to align to where?
What's the data type of the source data, numeric or string? Which format parameter are you currently using?

0 Votes 0 ·
kumarrr avatar image kumarrr OlafHelper-2800 ·

81606-image.png



I need to align Positive and Negative numbers in Tablix. Refer above screenshot.
I am using a numeric data type.

0 Votes 0 ·
image.png (6.1 KiB)
DJAdan-4490 avatar image
0 Votes"
DJAdan-4490 answered

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered Zoehui-MSFT commented

Hi @kumarrr,

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




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

May I know how's the issue going on now?

0 Votes 0 ·