|How to hide crosstab columns at runtime (in Excel) [message #896524]
||Wed, 18 July 2012 12:45
| Matt Rhoads
Registered: July 2012
I am trying to hide columns (levels) that don't have data in a crosstab. But the only way I can find to actually remove the column when exporting to Excel is to change the column width to 0.
However, I also have header labels in a grid (tried table as well) above the crosstab levels that will also need to set the column with to 0 for the same column below it.
I can get the columns to hide in script, but since setting the column width appears to be required in the onPrepare event for the column (anything later than this won't change the column width), I don't know how to see if there is data in the dataset before this happens.
I tried a hidden table above this table to calculate the existence of data, but I can't seem to get it to work.
Any help is greatly appreciated.
Powered by FUDForum
. Page generated in 0.07466 seconds