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?
Instead of using autodetection you can specify explicitely what you want in the query
<Query>
...
<ElementPath> Head{ID, Title, Text, Amount} </ElementPath>
</Query>
|||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.
See this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=376677&SiteID=1
-- Robert
No comments:
Post a Comment