How to pass array field to Birt?

Suchandra

I have a table field which can hold an array of values.How can i pass the field in Birt?

JoshiS

If SDR is the column name and you receive SDR as comma separated value i.e. A,B,C,D,E,F,G etc
Then

You can write as expression by selecting SDR data field from the table
as follows

if(dataSetRow["SDR"].indexOf(",")==-1)
{
dataSetRow["SDR"] =dataSetRow["SDR"];
}
else
{
array = dataSetRow["SDR"].split(',');
dataSetRow["SDR"] ="Name : "+array[0]+"nAddr1: "+array[1]+"nAddr2: "+array[2]+"nAddr3: "+array[3]+"nCity :"+array[4] +"nState :"+array[6]+"nSubscriber Status:"+array[7]+"nActivation Date :"+array[8]+"nDe-Activation Date:"+array[9]+"nSubscriber Type:"+array[10]+"nService Type:"+array[11];
}