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. |