Row visibility not working in RDLC layout in business central

(1) Share

Report

Posted on by Test user

333

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.

All responses (5)

Answers (1)

Sort by

Verified answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
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

Touil Yahya 220 on at

Like (1)

Report
Copy link

Link copied!
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 333 on at

Like (1)

Report
Copy link

Link copied!

Hi Mohamed Amine Mahmoudi

Thanks ,its working.
Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

good news.
please verify the answers.

Best regards,

Mohamed Amine MAHMOUDI
Test user 333 on at

Like (1)

Report
Copy link

Link copied!

Mohamed Amine Mahmoudi

Yes,I am trying to tick this,but it does'nt work.that's why answer is not verfied.