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
|
Doesn’t allow data to be on the same row.
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>
