Hitachi Vantara Pentaho Community Wiki
Access Keys:
Skip to content (Access Key - 0)

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


This documentation is maintained by the Pentaho community, and members are encouraged to create new pages in the appropriate spaces, or edit existing pages that need to be corrected or updated.

Please do not leave comments on Wiki pages asking for help. They will be deleted. Use the forums instead.

Adaptavist Theme Builder Powered by Atlassian Confluence