XML returned wont allow me to modify it

Question

Really basic level stuff here. I used an XML datasource to populate my report from passed xml. however, trying anything like Round, CDate, etc on the data causes #Error, and using the formatting tab to do the same conversions shows no change.

Can anyone help?

Answer 1

bump?

For example, i can do IsNumeric() on a field... returns True. I try to actually manipulate the data, nope. #Error. What's wrong?

Answer 2

bump. Still experiencing this issue. I know it's because the <Query></Query> is done at the report level. Is there really nothing I can do?

Answer 3

another bump...

Answer 4

Hi TheTurdFerguson,

From your description, it seems that you create the dataset query by including an XML Query or an element path. The XML Query starts with a <Query> tag and includes namespaces and XML elements that vary depending on the data source.  An element path is namespace-independent and specifies which nodes and node attributes to use from the underlying XML data with an XPath-like syntax.

At this time, I suggest that you verify the XML Schema. To do this, you can run this query in the Query Designer, but exclude everything between the <ElementPath IngnoreNamespaces="true"></ElementPath>. This will return the Dataset ID, Field Names, Data Types, etc. With this information, you may construct the element path accordingly.

For more information, please see:
XML Query Syntax for Specifying XML Report Data

Also there is a sample for your reference:
Using XML Data Source type and Querying a Web Service

Hope this helps,

Regards,
Mike Yin

 

Answer 5

Hi TheTurdFerguson,

From your description, it seems that you create the dataset query by including an XML Query or an element path. The XML Query starts with a <Query> tag and includes namespaces and XML elements that vary depending on the data source.  An element path is namespace-independent and specifies which nodes and node attributes to use from the underlying XML data with an XPath-like syntax.

At this time, I suggest that you verify the XML Schema. To do this, you can run this query in the Query Designer, but exclude everything between the <ElementPath IngnoreNamespaces="true"></ElementPath>. This will return the Dataset ID, Field Names, Data Types, etc. With this information, you may construct the element path accordingly.

For more information, please see:
XML Query Syntax for Specifying XML Report Data

Also there is a sample for your reference:
Using XML Data Source type and Querying a Web Service

Hope this helps,

Regards,
Mike Yin

 

Umm... that has nothing to do with what I'm asking. I'm asking how I can modify columns returned by the XML query. The only time I mentioned datatypes was mentioning that it didnt work in converting them at all, but yet would return true if ISNumeric() was performed.

Answer 6

bump

Answer 7

to the top. anyone please?

Answer 8

to the top.

Answer 9

bump. still need help here guys... please?

Answer 10

bump again

Answer 11

bump again.... this is getting ridiculous