SBX - Search With Button

SBX - Forum Post Title

Rdlc Report Visibility Problem

Microsoft Dynamics NAV Forum

sjen asked a question on 6 Jun 2019 9:26 PM

Question Status

Verified

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.

k0q1kelzvbyl.png

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

Reply
SamCha responded on 7 Jun 2019 2:32 PM
My Badges
Verified Answer

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

Reply
sjen responded on 7 Jun 2019 4:49 PM

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

IsNothing worked thank you

Visibility was already false with an expression.

Reply
SamCha responded on 7 Jun 2019 2:32 PM
My Badges
Verified Answer

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

Reply

SBX - Two Col Forum

SBX - Migrated JS