Formatting RDL/RDLC values as percentage

I thought I’d share how to format percentage values in ReportViewer report.
Say your data source has the following fields:

  • TotalLow
  • TotalHigh
  • Total

Suppose we want to display the values for TotalLow and TotalHigh as  percentage of Total.

We can use the following expressions.
=String.Format(“{0:p0}”,Sum(Fields!TotalLow.Value)/Sum(Fields!Total.Value))
=String.Format(“{0:p0}”,Sum(Fields!TotalHigh.Value)/Sum(Fields!Total.Value))

You notice the RDL/C allows you to use .NET String object Format method.

Hope this helps.

One thought on “Formatting RDL/RDLC values as percentage

  1. If you're looking to find blockchain developers, I would suggest checking some of the online platforms. Whether you are looking to grow your in-house staff, hire blockchain developer on a freelance basis, or contract a consulting firm, here are several ideas to help you blockchain hiring companies.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.