Jazz Reporting - How do I get a List view?
In regards to how the data is concatenated. I am currently trying to get data as a List view as opposed to Append or Merge view as shown below in the tables.
<o:p> </o:p>
For example,
For the Append view, it looks like the following:
ID | Hazard | Cause | Control | Additional Control |
1 | Haz_A | Cause_1 | ||
1 | Haz_A | Cause_2 | ||
1 | Haz_A | Cause_3 | ||
1 | Haz_A | Control_1 | ||
1 | Haz_A | Control_2 | ||
1 | Haz_A | Control_3 | ||
1 | Haz_A | Control_4 | ||
1 | Haz_A | AdControl_1 | ||
1 | Haz_A | AdControl_2 | ||
2 | Haz_B | Cause_1 | ||
2 | Haz_B | Control_1 | ||
2 | Haz_B | Control_2 | ||
2 | Haz_B | AdControl_1 |
<o:p> </o:p>
For the Merge view, it looks something like the following:
ID | Hazard | Cause | Control | Additional Control |
1 | Haz_A | Cause_1 | Control_1 | AdControl_1 |
1 | Haz_A | Cause_2 | Control_2 | AdControl_2 |
1 | Haz_A | Cause_3 | Control_3 | AdControl_1 |
1 | Haz_A | Cause_1 | Control_4 | AdControl_2 |
1 | Haz_A | Cause_2 | Control_1 | AdControl_1 |
1 | Haz_A | Cause_3 | Control_2 | AdControl_2 |
1 | Haz_A | Cause_1 | Control_3 | AdControl_1 |
1 | Haz_A | Cause_2 | Control_4 | AdControl_2 |
1 | Haz_A | Cause_3 | Control_1 | AdControl_1 |
2 | Haz_B | Cause_1 | Control_1 | AdControl_1 |
2 | Haz_B | Cause_1 | Control_2 | AdControl_1 |
Simply just gets a combination of every possible set which can be messy. <o:p> </o:p>
For the desired List view, I would like it to look like the following: <o:p> </o:p>
ID | Hazard | Cause | Control | Additional Control |
1 | Haz_A | Cause_1 | Control_1 | AdControl_1 |
1 | Haz_A | Cause_2 | Control_2 | AdControl_2 |
1 | Haz_A | Cause_3 | Control_3 | |
1 | Haz_A | Control_4 | ||
2 | Haz_B | Cause_1 | Control_1 | AdControl_1 |
2 | Haz_B | Control_2 |
From a visual perspective, the List view is better and convenient.
How can I configure my report so that I get the List view output? <o:p> </o:p>