I'm trying to create a report in table format from a dynamically generated XML file.
The report should look like the attached image and sample XML data below.
Most of the columns are dynamic meaning that column header labels can change and the total amount of columns can change also.
I'm fine with loading the data in but i'm not sure what components to use in the report builder to achieve this.
Code: Select all
<history>
<history>
<address>Bcontract Ltd Bridge St, WS1 1HP</address>
<BTflyVent>0xB22D00</BTflyVent>
<Cill>0xFFFFFF</Cill>
<CMoS>0x00B200</CMoS>
<contractId>142</contractId>
<contractName>Benx - Lonsdale Chambers</contractName>
<CSoM>0xB22D00</CSoM>
<masterClientAddress5>WS1 1HP</masterClientAddress5>
<masterClientDateSurveyed>2019-04-17</masterClientDateSurveyed>
<masterClientFullname>Survey 2</masterClientFullname>
<masterClientId>190</masterClientId>
<percentComplete>0</percentComplete>
<PoS>0x00B200</PoS>
<surveyorId>9</surveyorId>
</history>
<history>
<address>Bcontract Ltd Bridge St, WS1 1HP</address>
<BTflyVent>0x00B200</BTflyVent>
<Cill>0x00B200</Cill>
<CMoS>0x00B200</CMoS>
<contractId>142</contractId>
<contractName>Benx - Lonsdale Chambers</contractName>
<CSoM>0x00B200</CSoM>
<masterClientAddress5>WS1 1HP</masterClientAddress5>
<masterClientDateSurveyed>2019-04-23</masterClientDateSurveyed>
<masterClientFullname>Survey 3</masterClientFullname>
<masterClientId>198</masterClientId>
<percentComplete>0</percentComplete>
<PoS>0x00B200</PoS>
<surveyorId>9</surveyorId>
<VTPSeals>0x00B200</VTPSeals>
</history>
<history>
<address>Bcontract Ltd Bridge St, WS1 1HP</address>
<BTflyVent>0xFFFFFF</BTflyVent>
<Cill>0xB22D00</Cill>
<CMoS>0x00B200</CMoS>
<contractId>142</contractId>
<contractName>Benx - Lonsdale Chambers</contractName>
<CSoM>0xB22D00</CSoM>
<LScutsO>0x00B200</LScutsO>
<masterClientAddress5>WS1 1HP</masterClientAddress5>
<masterClientDateSurveyed>2019-04-26</masterClientDateSurveyed>
<masterClientFullname>Survey 4</masterClientFullname>
<masterClientId>219</masterClientId>
<percentComplete>0</percentComplete>
<PoS>0x00B200</PoS>
<surveyorId>9</surveyorId>
<VTPSeals>0x00B200</VTPSeals>
</history>
<history>
<address>Bcontract Ltd Bridge St, WS1 1HP</address>
<BTflyVent>0x00B200</BTflyVent>
<Cill>0xFFFFFF</Cill>
<CMoS>0x00B200</CMoS>
<contractId>142</contractId>
<contractName>Benx - Lonsdale Chambers</contractName>
<CSoM>0xB22D00</CSoM>
<IsizeG200>0x00B200</IsizeG200>
<LScutsO>0xB22D00</LScutsO>
<masterClientAddress5>WS1 1HP</masterClientAddress5>
<masterClientDateSurveyed>2019-04-23</masterClientDateSurveyed>
<masterClientFullname>Survey 1</masterClientFullname>
<masterClientId>142</masterClientId>
<MfixType>0x00B200</MfixType>
<percentComplete>0</percentComplete>
<PoS>0x00B200</PoS>
<STatAbut>0x00B200</STatAbut>
<StressP>0x00B200</StressP>
<surveyorId>9</surveyorId>
<VTPSeals>0x00B200</VTPSeals>
</history>
</history>