deleting column

Hello BIRT community, 
 
how can I delete column from the table in run-time using the API without errors? 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
...
TableHandle table = (TableHandle) designHandle.findElement("table");
table.getColumns().get(0).drop();
...
</pre>
 
or via for-loop with the getColumnCount(). 
 
I can delete the columns from the table but the design after saving it to a rptdesign file gives errors (inconsistent column count) because the headers and details and the data binding still are there. 
 
Thanks in advance for any suggestions.

Find more posts tagged with

Comments

JasonW

Kosta,

Clear the row cells first.

TableHandle th = (TableHandle)report.findElement("mytable");
RowHandle header = (RowHandle) th.getHeader( ).get( 0 );
header.getCells().get(0).drop();
RowHandle detail1 = (RowHandle) th.getDetail().get( 0 );
detail1.getCells().get(0).drop();
RowHandle footer = (RowHandle) th.getFooter( ).get( 0 );
footer.getCells().get(0).drop();
th.getColumns().get(0).drop();

Jason

kosta

Hi Jason, 
 
I tried this one and it work. 
But when the table has group I was using something like: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
TableGroupHandle tgh = (TableGroupHandle)table.getGroups().get(0);
RowHandle header = (RowHandle)tgh.getHeader().get(0);
CellHandle tcell = (CellHandle) header.getCells( ).get( 0 );
tcell .drop()
</pre>
 
I can see that the group cell is dropped but the group head appears in new column. 
 
Have I missed something? 
 
Thanks in advance.

kosta

I made an example rptdesign file for this case:

JasonW

Kosta,

Is there something wrong with the example you posted? It seems to work for me.

Jason

kosta

JasonW

you did not drop that cell. Do this:
var tgh = mytable.getGroups().get(0);
var header = tgh.getHeader().get(0);
var tcell = header.getCells( ).get(0);
tcell.drop();

Jason

kosta

Thanks a lot, I wonder how could I forget that.

Hosein

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="74877" data-time="1300746860" data-date="21 March 2011 - 03:34 PM">
you did not drop that cell. Do this: 
var tgh = mytable.getGroups().get(0); 
var header = tgh.getHeader().get(0); 
var tcell = header.getCells( ).get(0); 
tcell.drop(); 
 
Jason </blockquote>
 
Hi 
How can i drop second or third column ? above code only drops first column , i changed 0 to 1 but no column deleted. 
 
Thanks in advance 
S.M.H.Jamali

kosta

Hi Hosein,

it depends how your table is build.
You must delete all cells that are bound to that column,
and at the end you can delete the column itself.

The real fun begins when you have colspans and rowspans.
Then to find the real cell's is a little bit tricky.
Beside dropping you must modify some of the other cells.
It depends how your table is build.

Cheers.