Adding labels and data to chart by scripting

In this example, a table and a chart are added to the design. The table has a repeating body row.

Figure 34

The design in Document view

The Document panel tree shows there is a text area with a table and a chart. The table has a header row and a repeating body row.

 

Figure 35

The Document panel tree

As the icon to the left of the Text object indicates, a script is added before the text area. The script tokenizes a string of month names into an array of the month names called $labels. It also creates two numeric arrays, $x and $y which are populated with specific numbers for each instance of the $labels array.

The script looks as follows:

Example 22

Script before text area

$count = StrTok( "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",", $labels );

$i = 0;

while( num( $i ) < num( $count ) )

{

$x[$i] = $i;

$y[$i] =  num($i) * (num($count) - num($i));

$i++;

}

 

The repeater that repeats the table body row has XPath $labels specified on it. The chart uses the same variable for the x-axis label modification. For each value of $labels, the body row is repeated and the curve is drawn.

When run through the StreamServer with input data, this gives the following result:

Figure 36

The output

For information on XPath, see XPath.

For information on scripting functions, see the StreamServe Scripting Reference.