# Cross Tab Component - Hide Columns with N/A Values Dynamically

**URL:** <https://forum.inductiveautomation.com/t/cross-tab-component-hide-columns-with-n-a-values-dynamically/113827>\
**Category:** Ignition\
**Tags:** reporting\
**Created:** [February 7, 2026, 9:22am UTC](https://forum.inductiveautomation.com/t/cross-tab-component-hide-columns-with-n-a-values-dynamically/113827 "2026-02-07T09:22:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sudhanthiralakshmi\_M](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@Sudhanthiralakshmi\_M](https://forum.inductiveautomation.com/u/Sudhanthiralakshmi_M)\
**Post date:** [February 7, 2026, 9:22am UTC](https://forum.inductiveautomation.com/t/cross-tab-component-hide-columns-with-n-a-values-dynamically/113827/1 "2026-02-07T09:22:11Z")

</div>

Hello,

I'm using a **Cross Tab component** in the Ignition Reporting module to display dynamic columns based on data from a database query. My issue is that when certain columns don't have data for specific row groups, the cross tab displays `<N/A>` values, creating many empty/irrelevant columns.  
**Cross Tab Configuration:**

- Data Key:

- Header Columns: 2

- Header Rows: 1

- Rows: 1

**Problem:**  
Different descriptions have different relevant INFO\_DESC values. For example:

- Description Type A has data for 3 specific INFO\_DESC columns

- Description Type B has data for 3 different INFO\_DESC columns

However, the cross tab shows all possible INFO\_DESC columns for all descriptions, filling irrelevant cells with `<N/A>`. This creates a cluttered report with many empty columns showing N/A values.

**What I've Tried:**

- Looking for "Suppress Empty Columns" property (doesn't exist in Ignition cross tab)

- Filtering the query with `WHERE INFOS NOT LIKE '%N/A%'` - but the N/A values are generated by the cross tab itself when data doesn't exist for a particular INFO\_DESC

**Goal:**  
Display only the relevant columns for each description in a **single cross tab component**. Each description should dynamically show only its applicable INFO\_DESC columns without displaying N/A-filled columns.

**Questions:**

1. Is there a way to suppress/hide columns in a cross tab that only contain null or N/A values?

2. Can I use conditional column display or expressions to achieve this?

3. Should I restructure my data query differently to achieve dynamic column behavior?

Any suggestions would be greatly appreciated!