4.1 Running a Query
Normally, you will bind a query to a report element using the 'Data Binding' dialog box (or the equivalent property, e.g., query). The query that you bind will execute automatically when the report is generated, and the data returned by the query will populate the associated element.
In some situations, however, a report element must contain results from more than one query. For example, a summary table may display summary data generated from different queries. One way to do this is to construct a “master query” that provides all the desired aggregates, and then bind this single query to the element. However, this kind of query might prove very complex and difficult to write.
An easier way to bind multiple queries is to run the individual queries using script. You can then bind results from each distinct query to the individual table cells that you want to display those results. The following sections examine how to do this.
See Also
Formula Tables, for the most common application of multiple query binding.
Data Binding, in Report Design, to bind an element to a query.
| << 4 Queries | © 1996-2013 InetSoft Technology Corporation (v11.4) | 4.1.1 Running a Query from Script >> |