Skip to main content

Notifications

Business Central forum
Suggested answer

Row visibility not working in RDLC layout in business central

Posted on by 65
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.
 

 

 

 
 
 
  • Community member Profile Picture
    Community member 65 on at
    Row visibility not working in RDLC layout in business central
    Yes,I am trying to tick this,but it does'nt work.that's why answer is not verfied.
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 4,429 User Group Leader on at
    Row visibility not working in RDLC layout in business central
    Hi,
     
    good news.
    please verify the answers.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Community member Profile Picture
    Community member 65 on at
    Row visibility not working in RDLC layout in business central
    Thanks ,its working.
     
  • Suggested answer
    T.yahya Profile Picture
    T.yahya 96 on at
    Row visibility not working in RDLC layout in business central
    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
     
     
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 4,429 User Group Leader on at
    Row visibility not working in RDLC layout in business central
    Hi,
     
    try this :
    IIF((IsNothing(Fields!Ref_Item_Description.Value)=True) OR
    (Fields!Ref_Item_Description.Value=""),True,False)
    Best regards,
    Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Upcoming TechTalk: Copilot Capabilities…

Review the Copilot features that are currently available in Dynamics 365 Finance…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,405 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,370 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans