Display empty instead of 0

Hot Topic

error: Some parameters or credentials have not been specified
Can't uninstall old .NET compact framework
Authorization manager
Building Avalon applications in VS2005
Installing both Frameworks
when an Excel file is Opened it takes more than 1 minutes to open
the solution for crystal report error in C#(fail to import report)
How to use aspnet_compiler in team build (tfsbuild.proj)?
Reading Excel From C#
Custom/User Controls

Visual Studio

Build an Action Pane Across All Document Types?
crystal report for .NET redist
Debugger doesn't work
IIS Config for Crystal Reports on Windows Server 2003
How do you remove outdated history information?
Cristal Report by a Typed Dataset
Changing the property accessor
Can we have a reporter header
Dependency Property
Visual Studio 2005 perfomance issue

Display empty instead of 0

I use an expression in a TextBox:

Fields!myField.Value/10

myField is a type of integer in SqlServer.
If the value in myField is null, the expression "myField.Value/10" will display 0,

I want  the expression to display empty if myField is null.

How can I do that

Answer this question

Display empty instead of 0

  • Taffy III

    try this:

    =iif(Fields!myField.Value/10=0, "", Fields!myField.Value/10).

    Good Luck.

    Long

  • qubits

    You can also take advantage of the IsNothing() function.
  • Display empty instead of 0
Answer this question