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:
Columns: 1
-
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:
-
Is there a way to suppress/hide columns in a cross tab that only contain null or N/A values?
-
Can I use conditional column display or expressions to achieve this?
-
Should I restructure my data query differently to achieve dynamic column behavior?
Any suggestions would be greatly appreciated!