Previous Next

Sorting and Grouping Data : Tutorial 2: Grouping report data : Task 6: Display credit limit ranges in the group header

Task 6:

Rather than display the first value of each group in the group header, the report is easier to navigate if it displays the credit limit range for each group, as follows:

0 - 49999
50000 - 99999
100000 - 149999

This procedure shows how to write a JavaScript expression to display these credit limit ranges. The procedure also shows how to create a column binding with which to associate the JavaScript expression.

1
2
New Data Binding, shown in Figure 8‑9, prompts you to create a column binding for the new data element.

Figure 8-9 New Data Binding

Figure 8-9
3
1
CREDIT_GRP_HEADER

2
3
for(i=50000; i<300000; i+=50000){
if( row["CREDITLIMIT"] < i ){
rangeStart = i-50000;
rangeEnd = i-1;
break;
}
}
displayString = rangeStart + " - " + rangeEnd;
Choose OK. The expression appears in the Expression field on New Data Binding, as shown in Figure 8‑10.

Figure 8-10 Column binding defined

Figure 8-10
4
In the layout editor, the data element displays the column binding name, [CREDIT_GRP_HEADER].
4
5

Figure 8-11 Report preview showing credit limit ranges

Figure 8-11
Report preview showing credit limit ranges

(c) Copyright Actuate Corporation 2008