Grouping for WSDL data repeats first group in a nested group
I am using BIRT with a WSDL interface that returns a dataset of the type below
Group, vehicle, time, location
groupA, vehicle1, 5.30pm, address1
groupA, vehicle1, 5.35pm, address2
GroupA, vehicle2, 5.40pm, address3
GroupB, vehicle3, 5.40pm, address4
GroupB, vehicle4, 5.30pm, address5
GroupC, vehicle5, 5.40pm, address6
I group by 2 fields, firstly "Group" and then by "Vehicle". These are both strings.
When I report, everything looks exactly as I would expect with groups and vehicles nested correctly as as follows:
Group A
...........Vehicle 1
...........................DATA
...........Vehicle 2
...........................DATA
Group B
...........Vehicle 3
...........................DATA
...........Vehicle 4
...........................DATA
Group C
...........Vehicle 5
...........................DATA
Where "DATA" represent the detail rows with time and location.
The problem comes when I use the Table of Contents (TOC). I set the TOC Item Expression to the same value as the row itself, so 'row["groupName"]' for group and 'row["vehicle"]' for vehicle. I would expect the following TOC, were I to open the tree nodes fully:
Group A
...........Vehicle 1
...........Vehicle 2
Group B
...........Vehicle 3
...........Vehicle 4
Group C
...........Vehicle 5
In other words, there are 3 'root' nodes Group A, Group B and Group C. However, I get the following:
Group A
...........Group A
.........................Vehicle 1
.........................Vehicle 2
...........Group B
.........................Vehicle 3
.........................Vehicle 4
...........Group C
.........................Vehicle 5
So instead of 3 root nodes for groups A, B & C I get a single root node called "Group A" and then inside that Group, there are nodes for Groups A, B and C. So Group A is shown twice. In fact whenever I test on real data, whatever the first group is the same thing happens (though obviously different names)
Interestingly, when I click on the root node "Group A" it jumps to the first row of the report which is the column headings. When I click on the nested Group A, it jumps to the correct place which is the next line down, the first row of actual data (ie where Group A really does start).
Does anyone have experience of this or any advice? Apart from this, I am finding the BIRT an outstanding product...
