[Solved] Number Format : Blank when Zero

[Tommy]

Much like SSRS is there a way in Telerik Reporting to set a number format that is "Blank when Zero"?

[Eric R | Senior Technical Support Engineer]

Hi Tommy,

The best way to achieve this is to use our Expression Editor for the Value field of the TextBox. Let me review an example below. 

Logical Expressions Sample

With a sample data set that includes 0 for the amount, we can use a Logical IIF Expression to display the alternate value when the field is 0. 

Sample Data Set

ID,Amount
1,100
2,200
3,0
4,400
5,500
6,600
7,0
8,800
9,900

Logical IIF Expression

Designing this would look like the following screenshot.

The above produces the following output.

Wrapping Up

For additional reference, I have attached a sample that illustrates the design.

Please let me know if you need any additional information. Thank you for using Telerik Reporting.

Regards,

Eric R | Senior Technical Support Engineer
Progress Telerik

[Tommy]

Perfect just what I needed!