3.7.1 Extracting Data from a Query

To populate a formula table with data from a query result set, execute the query using the runQuery() method and save the result in a variable.

You should generally call the runQuery() method within the onLoad Handler.

var q = runQuery('customers');

You can then selectively extract parts of that query result set (see Referencing Query Data) and fill the cells of your formula table.

<< 3.7 Formula Tables © 1996-2013 InetSoft Technology Corporation (v11.5) 3.7.2 Extracting Data from a Report Element >>