Eclipse Community Forums: BIRT » Report Repeating First Line of Data

Help

Home

Home » Archived » BIRT » Report Repeating First Line of Data(Data Script Issue?)

Show: Today's Messages :: Show Polls :: Message Navigator

Report Repeating First Line of Data [message #986424]

Tue, 20 November 2012 11:43

Matthew Swain

Messages: 2
Registered: November 2012

Junior Member

Hi,

I'm a new user, learning as I go using old templates as examples to work from. I'm trying to sort out the data set for an invoice report. I can get the report to fetch the correct details and it has the correct numbered list of items but it continually produces just the first set of data for each item.

For example - on an Invoice where there are 7 different items to charge for, the report produces 7 lines of data but each line is a repeat of the first. The final totals are correct.

No. Job No. Amount
1 12 £200.00
2 12 £200.00
3 12 £200.00
4 12 £200.00
5 12 £200.00
6 12 £200.00
7 12 £200.00

Net Total £860.50

The script for the data set runs as follows:-

Open
iterator = providerInvoice.getActivities().iterator();
counter = 0;

Fetch
if (!iterator.hasNext()) {
return false;
}

var activity = iterator.next();
counter++;
row["count"] = counter;
row["idNumber"] = activity.getIdNumber();
row["combinations"] = activity.getTask().getLanguageCombination().getDisplayName();
row["activityType"] = activity.getActivityType().getDisplayName();
row["startDate"] = dateFormatter.format(activity.getStartDate());
row["totalAgreed"] = providerInvoice.getCurrency().getSymbol() + " " + currencyFormatter.format(activity.getTotalAgreed());
return true;

Close
iterator=null;

Any help would be appreciated and if additional infomation is required please let me know and I'll try and provide it for you.

Thank you,

Matthew

Report message to a moderator

Re: Report Repeating First Line of Data [message #986561 is a reply to message #986424]

Tue, 20 November 2012 23:22

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Are the data elements in your detail row bound to the dataSet as well? If so, this will happen. If they are, remove the dataSet bindings to these elements. If not, can you attach your report?

Michael

Developer Evangelist, Silanis

Report message to a moderator