September 08, 2008
Submitted by Eric Landry, Pentaho Community Member

Overview 

This tech-tip describes how to create and publish a report using data from an XQuery.

Step 1 - Create the Report

Open Pentaho Report Designer and create a new report called 'foo.report'. Don't add data sources in the Report Designer. In this report, add a Text Field and a Image URL Field element to the Page Header band. In the Item Band band, add a SubReport element.

In the SubReport that'll be called 'bar.report', add a Label element in the Report Header band and a Text Field in the Item Band band. Save and close the SubReport.

In the main report, click on the SubReport placeholder. In the Properties window, enter a Query name such as 'barQuery'.

Step 2 - Publish the Report 

In Report Designer, publish the report to the BI Server. This will take the two files ('foo.report' and 'bar.report') and combine them into a report definition file (foo.xml). Publishing will also create 'foo.xaction' and 'foo.properties'.

Step 3 - Modifying the Action Sequence

 In the Eclipse Pentaho Studio, open 'foo.xaction'.