How to display different percent in report

Yun 40 Reputation points
2024-12-24T06:39:08.7633333+00:00

I have set the percentage as 5.2%, when it is 5%, it will show as 5.0%.

I want to remove the decimal when it comes with whole value.

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,960 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 38,951 Reputation points
    2024-12-24T08:17:16.3433333+00:00

    Hi @Yun,

    Not sure about your original data, let's set it like shown below.

    And then you may use expression to get what you want.

    =IIF(Fields!data.Value * 100 = CINT(Fields!data.Value*100), format(Fields!data.Value,"0%") , format(Fields!data.Value,"0.0%"))

    User's image

    Regards,

    Zoe Hui


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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.