Small and medium business | Business Central, N...

How to hide & show column dynamically in RDLC report.

(0) Share

Report

Posted on by Nilam Bhor

153

Hi Guys,

Is there is any way, to hide & show column dynamically in RDLC report.

For Example: column should be visible only if there is data in that column, otherwise column will be hide if there is no data in that column.

Let me know, if there are any ways to do this.

I have the same question (1)

All responses (6)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Yes, you can set the Hidden property based on the conditions.

learn.microsoft.com/.../how-to--apply-conditional-visibility-controls

Was this reply helpful? Yes No
Suggested answer

CU28050330-0 2 on at

Like (0)

Report

Thanks @Mohana Yadav, that worked perfectly!

I was able to set the column visibility using the Hidden property conditionally, just like you suggested. It’s exactly what I needed—now my RDLC report looks much cleaner without empty columns showing up.

https://learn.microsoft.com/en-us/dynamics-nav/how-to--apply-conditional-visibility-controls/subway surfers

Was this reply helpful? Yes No
VK_Karangiya_MCP 51 on at

Like (0)

Report

In the RDL file, select the desired column, navigate to its properties, and set the Visibility property using the expression:

=IIf(Fields!YourField.Value <> "", False, True)

This configuration ensures that the column remains visible only when YourField contains a non-empty value; otherwise, it will be hidden.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, You can refer to the standard practices below.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (0)

Report
Maybe this will help you implement it.

Yes, you can dynamically hide or show a column in RDLC based on data using the Visibility expression on the column.

✅ Steps to Hide Column Dynamically in RDLC:

Go to your RDLC layout (in Visual Studio).

Select the column (Textbox or TableCell) you want to hide.

Right-click → Column Visibility.

Set this expression in the visibility condition:

=IIf(Fields!MyField.Value = "", true, false)

Or if you're checking for NULL:

=IsNothing(Fields!MyField.Value)

This will hide the column if the field is empty or null.

📝 Note: You must apply this on all cells in the column, including the header.

Let me know if you need help with more complex visibility logic.

Mark below checkbox to make this answer Verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

Handling it in RDLC is the easiest approach but it can also be achieved by AL code with dedicated Flags. Code will be exactly the same but it will become a bit simple to understand as the same condition we will be putting in AL.

Was this reply helpful? Yes No