3.7 Formula Tables

Formula tables are used to create real-time, spreadsheet-like reports with highly specific or complex layouts. These tables can be used to implement the kind of data grouping and aggregation which is commonly required in accounting and financial applications.

Formula tables bridge the gap between spreadsheet applications (like Excel) and traditional reporting tools. In a spreadsheet, you usually start with columns of data and then define formulas that reference other cells. To copy these formulas with appropriate references you can 'fill-down' in a range of cells.

A formula table is similar. You extract parts of a query result set and then dynamically fill the rows and columns of the table. You can then reference these cells to perform statistical calculations in formulas. The 'fill-down' operation happens automatically when the table expands to show actual data.

Most of the common ways of using a formula table can be accomplished through the point-and-click GUI of Style Studio. Sometimes the GUI is not enough. The next sections discuss the fundamentals of using scripting to reference data from query results and table cells.

See Also

Formula Tables, in Report Design.

Accessing Table Data, for information about the table and data attributes.

<< 3.6.3 Displaying Images in Table Cells © 1996-2013 InetSoft Technology Corporation (v11.5) 3.7.1 Extracting Data from a Query >>