Skip to main content
Microsoft Dynamics NAV forum
Answered

Rdlc Report Visibility Problem

editSubscribe (0) ShareShare
ReportReport
Posted on by 55

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?

Categories:
  • sjen Profile Picture
    sjen 55 on at
    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 Profile Picture
    SamCha on at
    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).

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans