CrossTab Report Help

zkhalid

Hi All

I need some help regarding crosstab reports. I have created a datacube based on 2 datasets. One dataset for header and other for the detail rows. I have link the 2 groups in the cube on a key as well and the report is working fine. Only thing is if join key coming from headerDataSet is not present in detailDataSet the header itself disappears. I want it to show the crosstab header.

Example (What I want)

Users | HEADER 1 | HEADER 2 | HEADER 3 | HEADER 4

User1 | YES |

---

|

---

|

---

User2 |

---

| YES |

---

|

---

User3 |

---

|

---

|

---

| YES


Now problem is with HEADER 3 no user is associated with it. So the output comes from BIRT like

Example (What I get from BIRT)

Users | HEADER 1 | HEADER 2 | HEADER 4

User1 | YES |

---

|

---

User2 |

---

| YES |

---

User3 |

---

|

---

| YES

The HEADER 3 gets ignored so please help. I want the HEADER 3 to be included as well.
Help required urgently.

mwilliams

Hi zkhalid,

What version of BIRT are you using?

Also, what does your data look like in your two dataSets based on the above example?