Report Repeating First Line of Data [message #986424] |
Tue, 20 November 2012 06:43  |
Eclipse User |
|
|
|
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
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.28871 seconds