For every relational report you create, there are three essential Blox that you will need:
DataSourceConnectionBlox lets you connect to a relational data source defined to DB2 Alphablox. SQLDataBlox lets you specify the SQL command to extract the needed data from your data source. ReportBlox lets you generate the output in an HTML table. With these Blox you can produce your first relational report. Below is the JSP code needed for every report you create.
<!-- Importing the Blox Reporting Tag Library -->
<%@ taglib uri="bloxreporttld" prefix="bloxreport" %> <HTML> <HEAD> </HEAD> <BODY> <!--- Simplest report using a SQL Data Source ---> <bloxreport:report id = "Report1"> <bloxreport:sqlData query="SELECT... FROM... WHERE..." > <bloxreport:dataSourceConnection dataSourceName = "yourRDB" > </bloxreport:dataSourceConnection> </bloxreport:sqlData> </bloxreport:report> </BODY> </HTML>