<p>Hi,</p><p> </p><p>I have a cross tab with 3 summary columns. Due to design requirement i need to display only 2 columns, (i.e. hide one column).</p><p> </p><p>I tried it by couple of methods</p><p> </p><p>> I tried with the 'Visibility' option, Hide Element for all outputs.</p><p> </p><p>> by the java script method. </p><p> </p><p><strong class='bbc'>function</strong> onPrepareCell( cell, reportContext )</p><p>{</p><p>reportContext.getDesignHandle().getElementByID(189).setStringProperty("width","0px");<br />
reportContext.getDesignHandle().getElementByID(185).setStringProperty("width","0px");</p><p>}</p><p> </p><p>Both these does the trick, however there are some issues</p><p>> Even though the column is hidden, however in HTML format there is a small width still remaining.</p><p>> In XLSX, format we get an empty column.</p><p> </p><p>Aditionally when i try with the onPrepareCell</p><p> </p><p>function onPrepareCell( cell, reportContext )<br />
if(some condition){<br />
if( cell.getCellID() == cell#){<br />
cell.getStyle().setDisplay("none");<br />
}<br />
}</p><p> </p><p>This dosent work, since i have a Grand total column at the end and the report gets misaligned</p><p> </p><p>Is there any other way to achieve this, where the column gets hidden in XLSX format too ??<br />
</p>
