Rdlc Report Visibility Problem

(0) Share

Report

Posted on by sjen

Hello I am working on nav report and I have an empty string on my report line and I only want to display if my sales type not empty.

I went to empty string line and added visibility expression

=IIF(Fields!Sales_Line_Type.Value = " ",true,false)

It is almost working but still prints a line for the last line. I can add more line and the empty string line goes to the last line.

See the last empty line, I want that gone. How can I do that?

*This post is locked for comments

All responses (2)

Answers (1)

sjen 69 on at

Like (0)

Report

RE: Rdlc Report Visibility Problem

=(Fields!Sales_Line_Type.Value = " ") or (IsNothing(Fields!Sales_Line_Type.Value))

IsNothing worked thank you

Visibility was already false with an expression.
Verified answer

SamCha 14 on at

Like (1)

Report

RE: Rdlc Report Visibility Problem

If you want the blank space gone you need to set the visibility property on the Row (in the Row Groups at the bottom).