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. Since the example is in Europa M6, I will provide a simple description of the technique for 2.1 users.

The basic idea is that the JoinedDataSet UI needs a field to be able to join the two data sets. The problem is that even though we know both tables have equal numbers of rows, they may not have shared fields that can create a key. In this case, we create a calculated field in each table which we use as a the key.

For this example the key is really simple it is just the result of row["0"], which is an automatic rowNumber field. This same technique could be used to create more complex keys based on other logic or field values if that is what you need to do.

So all you have to do is add one computed column in each dataSet. The name of the column does not matter, but the value should be row["0"]. Then in your JoinedDataSet you select the two named columns.

Comments

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

---