Thursday, 10 October 2013

SSRS: Decimal places

Question: How to remove decimal point in SSRS cell's data?
Answer: In SSRS if it is required to remove decimal point from cell's data then need to set the format of number.

Example - If cells data is having the format like 2034.152. Then it would be 2034 after formatting.

or If cells data is having the format like 2034.652.Then it would be 2035 after formatting.

Follow the below steps -

Step 1 - Go to the cell's expression by right click and select expression.

Step 2 - Do the round of in to expression -









Now check your report preview,  I hope it should work.


Question: How to place two decimal places in SSRS cell's data?
Answer: In SSRS if it is required to place decimal points till two places in cell's data. Then need to set the format for cell's data.

Example - If cells data is having the format like 2034.1. Then it would be 2034.10 after formatting.

or If cells data is having the format like 2034.667.Then it would be 2034.67 after formatting.

Follow the below steps -

Step 1 - Go to the cell's expression by right click and select expression.

Step 2 - Set the format and round of in to expression -










Now check your report preview,  I hope it should work.

No comments:

Post a Comment