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.

Post a Comment

22 Comments

  1. Тhanks in support of sharіng such a pleasant thinking,
    post is nice, thats why i havï½… read Ñ–t completely
    anchor : 6 Ways To Avoid Encryption Software Bᥙrnout & Haven’t You
    Heard About The Recession: Topten Reasons Why Yoᥙ Should How To Encrypt A Pasѕword For Free

    ReplyDelete
  2. magnificent post, very informative. I'm wondering why the other specialists of this sector do not realize this.

    You should continue your writing. I'm sure, you've a great readers' base already!

    ReplyDelete
  3. It's very easy to find out any matter on net as compared to books, as
    I found this article at this site.

    ReplyDelete
  4. Spot on with this write-up, I honestly believe that this site needs much more attention.
    I'll probably be back again to read through more,
    thanks for the advice!

    ReplyDelete
  5. of course like your website however you need
    to take a look at the spelling on several of your posts.

    Several of them are rife with spelling issues and I find it very
    troublesome to tell the truth on the other hand I'll certainly come again again.

    ReplyDelete
  6. Just desire to say your article is as amazing.
    The clearness in your post is just spectacular and i could assume you
    are an expert on this subject. Well with your permission allow me to grab your RSS feed to keep up to date with forthcoming
    post. Thanks a million and please keep up
    the gratifying work.

    ReplyDelete
  7. Hi there I am so grateful I found your webpage, I really found you by mistake, while I was looking on Askjeeve for something else, Regardless
    I am here now and would just like to say kudos for a remarkable post and a all round
    interesting blog (I also love the theme/design), I don’t have time to read through it all
    at the moment but I have book-marked it and also added in your RSS feeds, so when I have time
    I will be back to read much more, Please
    do keep up the awesome work.

    ReplyDelete
  8. Hello there, You have done an excellent job. I will definitely digg it and personally recommend to my friends.
    I am sure they will be benefited from this web site.

    ReplyDelete
  9. Very descriptive post, I enjoyed that a lot. Will
    there be a part 2?

    ReplyDelete
  10. Heya i'm for the first time here. I found this board and I to find It truly useful & it helped me out much.

    I am hoping to provide one thing again and aid others such as you helped me.

    ReplyDelete
  11. I always spent my half an hour to read this webpage's
    posts everyday along with a cup of coffee.

    ReplyDelete
  12. If you are going for finest contents like I do, just pay
    a visit this web page everyday as it offers feature contents, thanks

    ReplyDelete
  13. My family every time say that I am killing my time here at web, however I know I am getting knowledge every day by reading thes good posts.

    ReplyDelete
  14. I have to thank you for the efforts you have put in writing this website.
    I'm hoping to check out the same high-grade content
    from you later on as well. In fact, your creative writing abilities has encouraged me to get my
    own website now ;)

    ReplyDelete
  15. This post presents clear idea designed for the new
    users of blogging, that in fact how to do blogging and site-building.

    ReplyDelete
  16. If some one needs to be updated with most recent technologies after that he must be pay a visit this web page and be up to
    date every day.

    ReplyDelete
  17. Thanks for sharing such a good idea, post is nice, thats why i have read it fully

    ReplyDelete
  18. Awesome issues here. I'm very glad to see your article.

    Thanks a lot and I am taking a look ahead to contact you.
    Will you kindly drop me a mail?

    ReplyDelete
  19. Thank you, I've recently been searching for info about this subject for
    ages and yours is the best I've discovered till now.
    But, what concerning the conclusion? Are you certain in regards to the
    source?

    ReplyDelete
  20. Good post. I learn something totally new and challenging on blogs I stumbleupon on a daily basis.
    It will always be interesting to read through articles
    from other authors and practice something from their websites.

    ReplyDelete
  21. Very nice article, just what I was looking for.

    ReplyDelete
  22. This design is incredible! You certainly know how to keep a reader
    entertained. Between your wit and your videos,
    I was almost moved to start my own blog (well, almost...HaHa!)
    Great job. I really loved what you had to say, and more
    than that, how you presented it. Too cool!

    ReplyDelete