Master Detail report

pdube1

Hi,

I want to create a master detail report, where the master section has more than one detail sections.

For example, I have 3 datasets:
1) (Master) Fetches the employees (userId, firtname, lastname);
2) (detail 1) Fetches the list of all goals of the employees (userId, goalName)
3) (detail 2) Fetch all working experience of the employees (userId, companyName)

The result I want would look like this:

---

User Id: First Name: Last Name:
01 John Smith

Goals Name:
-Get better result
-Be more efficient
-Get better scores
...

Working Experience:
-cie ABC
-cie xyz
...

User Id: First Name: Last Name:
02 Katy Sanders

Goals Name:
-Sell more
-Sign more contract
-Get better scores
...

Working Experience:
-cie DEF
-cie GHI
...

...

---

I've been able to achieve this by adding 2 sub tables in the master table and adding a filter on the subtables based on a variable set on the master table dataset row.
The problem with this is that the query of the sub tables are executed for each row of the parent data set. What I would have expected is that all 3 dataset are executed once and then birt do the filtering in the rendering phase.

I have also tried the grouping option on a table with a joint data set, but I'm not able to display the data like I want.

Is anybody have an idea how I could achieve this? Any help would be appreciated.

Thanks

mwilliams

What is your BIRT version?

You could use dataSet parameter bindings rather than filters. The queries would run for each outer table value, but they would only run for the value in the outer table and not for all and then filter them down. This would be the fastest way.