Row visibility not working in RDLC layout in business central

(1) Share

Report

Posted on by Nil@@m

181

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)

Nil@@m 181 on at

Like (1)

Report

Row visibility not working in RDLC layout in business central

Mohamed Amine Mahmoudi

Yes,I am trying to tick this,but it does'nt work.that's why answer is not verfied.
Mohamed Amine Mahmoudi 9,413 Super User 2024 Season 2 on at

Like (0)

Report

Row visibility not working in RDLC layout in business central

Hi,

good news.
please verify the answers.

Best regards,

Mohamed Amine MAHMOUDI
Nil@@m 181 on at

Like (1)

Report

Row visibility not working in RDLC layout in business central

Hi Mohamed Amine Mahmoudi

Thanks ,its working.
Suggested answer

T.yahya 105 on at

Like (1)

Report
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
Verified answer

Mohamed Amine Mahmoudi 9,413 Super User 2024 Season 2 on at

Like (2)

Report
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