Injecting Row

Hello,

is it posible to inject rows when a spezial condition match.

I have an offer an i want divide it in an timeline.

Project duration is 3 month and it goes from 100101 to 100331. The Offer is 30000€. When i join project and offer get projectName, startDate, endDate and offerAmount in one row.

myTestProject, 100101, 100331, 30000

I will have 3 rows
projectName, startDate, endDate, offerAmount/duration and periodkey.

myTestProject, 100101, 100331, 10000, 10-01
myTestProject, 100101, 100331, 10000, 10-02
myTestProject, 100101, 100331, 10000, 10-03

Is it posible to do this in an onfetch Event.

Greatz
Bernd

Find more posts tagged with

Comments

Virgil Dodson

Hi Bernd,<br />
<br />
I *think* the onFetch method is getting called once for each row as it is being created which means it may be too late to create new rows from inside here. Maybe you could use the scripted data source to iterate over your data and create the data set that way. There are some simple scripted data source examples in the DevShare on this site.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/544-sample-birt-scripted-data-source-example/#description'>Sample BIRT Scripted Data Source Example - Designs & Code - BIRT Exchange</a>