Skip to Content
0
Former Member
Nov 08, 2012 at 05:38 PM

How to dynamically hide columns with no data in Webi Xi 3.1 Sp4

93 Views

We are trying to dynamically hide columns with no data and only show columns that have data in our Web Intelligence reports. We also want to translate this to the same when exporting to Excel to show up only when there's data in certain columns.

So if we can show the report just as it is, with hidden columns to excel as well, that would be great.

We have 20 columns and we don't know when the column will have data or not, so we have to display the columns. We would like to dynamically hide columns (fields) that have no data without changing the sql query.

Can this be done today in XI 3.1 Sp4 or later Sp.