Joined Data Set - RowNumber (BIRT)

< To: Report Developer Examples (BIRT)
This example is Bugzilla ID 185387. If you would like to contribute an example see the example contribution guidelines.

Introduction

This is a short example that shows combining two tables using the JoinedDataSet based on the tables rowNumber field. In order to make this work, I need to create a calculated data field in each named RowNumber where the expression is row["0"]. I then use that field as the key in the JoinedDataSet.

BIRT Version Compatibility

This was done using BIRT M6.

Example Files

Add a URL to your bugzilla attachment. eg. JoinedDataSet on RowNumber report

Description

This is pretty limited, just wanted to show how to join two tables using the RowNumber as the common key. The tables in this case are Customer, that was done simply to make my life easy. In reality, the two tables do not need to match.

Comments

Please enter comments below by selecting the edit icon to the right. You will need a Bugzilla account to add comments.

---