Previous Next

Task 10:  Display credit limit ranges in the table of contents

Rather than display the first value of each credit limit group, the table of contents makes more sense if it displays the same credit limit range values as the report. You accomplish this task by using the same JavaScript expression that you used previously to display credit limit ranges (0 - 49999, 50000 - 99999, and so on) in the group header.

Edit Group, shown in Figure 8-30, displays the properties of the group. Under Table of Contents, Item Expression is set, by default, to the grouping field, row["CREDITLIMIT"].

Figure 8-30 Edit Group displaying the properties of credit_group

Figure 8-30  Edit Group displaying the properties of credit_group
Choose the expression builder button, and, in the expression builder, replace the row["CREDITLIMIT"] expression with the following expression. This expression is the same column-binding expression that is used by the data element, [CREDIT_GRP_HEADER], in the group header. Rather than typing the expression again, you can copy it from the data element and paste it here.
for(i=50000; i<300000; i+=50000){
if( row["CREDITLIMIT"] < i ){
  rangeStart = i-50000;
  rangeEnd = i-1;
displayString = rangeStart + " - " + rangeEnd;
Choose OK to save the expression.
Preview the report in the report viewer to verify the change in the table of contents. The table of contents displays the credit limit ranges, as shown in Figure 8-31.

Figure 8-31 Updated table of contents

Figure 8-31  Updated table of contents


(c) Copyright Actuate Corporation 2012