Blox for Relational Reporting


Blox available for Relational Reporting include the following. For an example that demonstrates most of these Blox and how they add up to transform the data, see An Example Demonstrating the Various Blox.

 
Blox
Description

ReportBlox

Generates a report based on the data result set produced by SQLDataBlox. The report can be rendered either in a static HTML table or a table in Dynamic HTML (DHTML) with interactive report editing functions.

SQLDataBlox

Executes a SQL query that can be executed against a data source and stores the result in result set.

DataSourceConnectionBlox

Represents a connection to a relational Alphablox data source.

RDBResultSetDataBlox

Allows you to feed a RDBResultSet object from a DataBlox to a ReportBlox.

CalculateBlox

Lets you add a calculated member based on the calculation expression you specify.

SortBlox

Sorts the data based on specified members, in ascending or descending order.

FilterBlox

Filters numeric data based on the criterion you specify.

GroupBlox

Supports grouping of data. By adding a GroupBlox to your ReportBlox, you can create break groups in your report and specify the type of aggregation-sum, average, count, max, or min-at the end of each break group.

MembersBlox

Lets you specify members to be included or excluded from the report.

OrderBlox

Lets you select members to be included or excluded. The order that the members are specified defines the order from left to right in which the members are returned to the result set, and therefore the name "OrderBlox."

FormatBlox

Lets you specify the display format for numeric and date data types. It also lets you define the text to display for missing data.

StyleBlox

Lets you set the fonts, colors, and positions of elements in the report. You can set banding style, style for missing, negative, and aggregation (group totals) values, and style for individual data columns.

TextBlox

Allows you to set the display text for group headers, group footers, group totals, column headers, and data cells.

PdfBlox

Renders a relational report in PDF with the layout you specify.

ErrorBlox

Generates an error report in an HTML table that includes the nested exceptions.

PersistenceBlox Lets you save the state of a ReportBlox for later retrieval.