again a problem with xml datasource extension

it seems to be that the xml datasource ignore empty fields. why

example:

< xml version="1.0" standalone="yes" >
<Head>
<ID>121234</ID>
<Title>Hi</Title>
<Text></Text>
<Amount>3443.90</Amount>
</Head>

Only ID, Title and Amount appearing in the resultset.

any suggestions



Answer this question

again a problem with xml datasource extension

  • Geno

    Instead of using autodetection you can specify explicitely what you want in the query

    <Query>
    ...
    <ElementPath> Head{ID, Title, Text, Amount} </ElementPath>
    </Query>



  • wayne hileman

  • malefly

    Dear Sasha, may be you know something about this error:

    The reports based on XML is perfectly displayed in development Environment.

    But than uploaded to Server, the following occurs:

    · An error has occurred during report processing.

    o An attempt has been made to use a data extension 'XML' that is not registered for this report server.

    Thank you very much.


  • again a problem with xml datasource extension