Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2706
  • Last Modified:

Suppress "Null" in report builder 3.0

I would like to suppress the <None> text so the field is just blank in the column shown in the screen shot. I am using report builder 3.0. Thanks for any assistance with this.

Null Field Example
0
srodgers45
Asked:
srodgers45
  • 3
  • 3
1 Solution
 
ValentinoVBI ConsultantCommented:
How is that "<None>" currently getting produced?  Does the dataset return it that way?  Is there any expression in the definition of the column that displays <None>?
0
 
srodgers45Author Commented:
It returns it that way. I do not want to suppress the report on that value, just show it blank if it's <None> I tried a =switch expression, I think I am doing it wrong.

Thx
0
 
ValentinoVBI ConsultantCommented:
Could you post your "switch" expression, normally it should be possible.

Also, any chance that you can modify the query in the dataset instead?  Or do you need the "none" to be actually returned to make the report work, just not shown?
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Alpesh PatelAssistant ConsultantCommented:
Based on value suppress it.Property
0
 
srodgers45Author Commented:
I just want to have the <None> field be empty but not suppress the entire report based on that.
0
 
ValentinoVBI ConsultantCommented:
Again, could you post the expression that you've tried already?

In the meantime, perhaps this helps?  To be used as expression for the value of the textbox:

=IIF(Fields!YourField.Value = "<None>", Nothing, Fields!YourField.Value)
0
 
srodgers45Author Commented:
Thanks, that switched expression was actually in another report. Thank for the help.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now