Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher - hide column only when all rows are null, RTF template

Received Response
96
Views
1
Comments
User_3Q57G
User_3Q57G Rank 1 - Community Starter

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