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?
If you want the blank space gone you need to set the visibility property on the Row (in the Row Groups at the bottom).
=(Fields!Sales_Line_Type.Value = " ") or (IsNothing(Fields!Sales_Line_Type.Value))
IsNothing worked thank you
Visibility was already false with an expression.
Business Applications communities