Stimulsoft Business Intelligence System | Forum

Posted: **Mon Apr 29, 2019 9:56 am**

Hi,

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>

Posted: **Tue Apr 30, 2019 9:22 am**

Hello,

Unfortunately, with the current data structure, it is not possible.
You can try to place all dynamic columns in a separate table and then use Cross-Data component for that task.

Thank you.

Posted: **Tue Apr 30, 2019 9:26 am**

Hello,

My data structure can be changed to suit the reports needs. What data structure would work?

Thanks.

David

Posted: **Fri May 03, 2019 9:40 am**

Hello,

please check the sample report in the attachment. Will work with any count of dynamic columns.

Thank you.

Posted: **Tue May 14, 2019 9:51 am**

Hello,

Thank you for providing that solution. That's exactly what i'm looking for.

Posted: **Tue May 14, 2019 1:07 pm**

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.

Stimulsoft Business Intelligence System | Forum

Creating a table with dynamic columns

Creating a table with dynamic columns

Re: Creating a table with dynamic columns

Re: Creating a table with dynamic columns

Re: Creating a table with dynamic columns

Re: Creating a table with dynamic columns

Re: Creating a table with dynamic columns