Table duplication

ravishanku

I have a collection with some datas. I have to print this datas in different tables..to understand more i have attached a file with this..the collection wil be as follows::<br />
Collection col = new ArrayList();<br />
col[0] = Ledger Head: SBI SB A/C NO: 123 ; <br />
col[1] = 31-Mar-2011 12:00 AM,1,cxc,0,210 (this is the first row see the attachment)....etc like wise it goes...and when it reaches col = another Ledger Head as it came in col[0] it should start printing in a new table same as above....<br />
<br />
pls anyone help..i am searching this for a long time..i am getting only methods for making dynamic table with dynamic dataset..but i think this is not what i want here...waiting for reply..<br />
<br />
Another thing is that, iteration of collection col is done in an EventHandler Class..in the fetch()...while this iteration of collection, the new table should be created....<br />
<br />
The EventHandler Class is as below......<br />
<br />
public class Testing extends ScriptedDataSetEventAdapter{<br />
<br />
Collection col = new ArrayList();<br />
int count = 0;<br />
Iterator it = null;<br />
DayBookBean foo = new DayBookBean();<br />
float tcred = 0,tdeb = 0;<br />
<br />
public void beforeOpen(IDataSetInstance dataSet, IReportContext reportContext)throws ScriptException {<br />
<br />
super.beforeOpen(dataSet, reportContext);<br />
col = (Collection)reportContext.getParameterValue("myResultSet"); //Retrieved collection through session<br />
}<br />
<br />
<br />
public void open(IDataSetInstance dataSet) throws ScriptException{<br />
<br />
super.open(dataSet);<br />
it = col.iterator();<br />
}<br />
<br />
public boolean fetch(IDataSetInstance dataSet, IUpdatableDataSetRow row)<br />
throws ScriptException {<br />
<br />
Boolean status = false;<br />
if(it.hasNext()) {<br />
status = true;<br />
foo = (DayBookBean)it.next();<br />
}<br />
else{<br />
status = false;<br />
}<br />
<br />
if(foo.getOflag()==1){ <br />
String head = "LEDGER HEAD: " + foo.getHeadName();<br />
row.setColumnValue("head",head);<br />
row.setColumnValue("Opbal", foo.getTotalopbalance());<br />
}<br />
<br />
row.setColumnValue("date", foo.getTransactionDate());<br />
row.setColumnValue("rtno", foo.getReceiptNo());<br />
row.setColumnValue("rtno",foo.getVoucherNo());<br />
row.setColumnValue("narration",foo.getNarration());<br />
row.setColumnValue("debit",foo.getDebit());<br />
row.setColumnValue("credit",foo.getCredit());<br />
<br />
return status; <br />
}<br />
<br />
Thanking you,<br />
Ravishankar

mwilliams

I'm not sure if I'm understanding correctly, but if I am, you should be able to create a column in your resultSet that just lists the "Ledger Head" value. Then when you create your table in your design, you can group on this value so the correct rows are associated with it, then there would be a new group header and footer for each section of the table with a different "Ledger Head" so you'd essentially have a new table for each "ledger head" value.

Hope this helps.