web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Row visibility not wor...
Small and medium business | Business Central, N...
Answered

Row visibility not working in RDLC layout in business central

(1) ShareShare
ReportReport
Posted on by Test user 305
Hi Guys,
I am facing one query with RDLC report.
I want to hide this row-> If that particular row is blank then it will hide.
I have write this condition on row visibility ,but still blank lines is visible on report.
Same condition I have write  for Ref_Item_Description & Ref_Item_Description2 this two rows.
 please see screenshots.
 

 

 

 
 
 
I have the same question (0)
  • Verified answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 26,449 Super User 2025 Season 2 on at
    Hi,
     
    try this :
    IIF((IsNothing(Fields!Ref_Item_Description.Value)=True) OR
(Fields!Ref_Item_Description.Value=""),True,False)
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    T.yahya Profile Picture
    T.yahya 163 on at
    Give this a shot:

    =IIF(Len(Fields!Ref_Item_Description.Value) <= 0, true, false) 
     
    The expression uses the IIF function to evaluate a condition and return a boolean value.
     
    The Len function is used to get the length of the string value in the Ref_Item_Description field.
    The IIF function then checks if the length of this string is less than or equal to 0.
    If it is, then the function returns true, otherwise it returns false.
     
    Hope this will help.
     
    Best regards,
    Touil Yahya
     
     
  • Test user Profile Picture
    Test user 305 on at
    Thanks ,its working.
     
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 26,449 Super User 2025 Season 2 on at
    Hi,
     
    good news.
    please verify the answers.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Test user Profile Picture
    Test user 305 on at
    Yes,I am trying to tick this,but it does'nt work.that's why answer is not verfied.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,116

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 764 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 635 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans