Categories
- All Categories
- 99 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 55 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
BI Publisher - hide column only when all rows are null, RTF template

I created a report using an RTF template. The report will have about 50 columns, but often most of the columns will be null.
The idea is to hide the columns that are null so they don't show up in the output file (.xlsx).
Also, I want to hide only columns that are completely null - no row has a record inside that column.
If at least one row in the column has a record - then it should not be hidden.
Let's say column is called "ORDER_NO", I created this condition:
<?if@column:ORDER_NO!=''?>
It works great when all rows are null, the column is hidden in output file. (example 2.)
When combined records are inside that column (null and not null) - the column is visible, records that are not null will be shown, and null records will be hidden - but only for that row.
Output gets messy and data from the right column (date) moves inside column ORDER_NO. (example 3.)
The output I would like to achieve (when records are combined null/not null) is example 4.
Also, I tried with condition:
<?if@cell:ORDER_NO!=''?>
The result was exactly the same.
Is it feasible? What am I doing wrong?
Thank you in advance!
Antonio
Answers
-
Hi,
Were you able to achieve this requirement?
If no, can you try below approach:
RTF file Configuration for Eliminating Null Value Column — Oracle Analytics
Thanks.
0