Cross table with two datasets (one as the row and the other as the column)

Question

I have two datasets in my birt report :

1. Lesson (date)
2. Student (name)

and I would like to know how to create a cross table using the date (red) as the column names and name (blue) as the row names as shown below :

The cells will stay empty.

I have try to use the Cross Tab but it seems that I can only use one dataset.

For information I am stuck with the version 2.5.2. I say this in case someone writes about a practical functionality available in the later version of birt... :-)

Answer 1

Where both datasets are coming from the same relational data source, the simplest way to achieve this would normally be:

• Replace the existing two datasets with a single dataset, in which the two original datasets are cross-joined to each other;
• create a crosstab from the new dataset, with the new dataset columns as the data cube groups.