I'm building reports in SSRS on SQL Server 2008 R2 using XML's as datasources for my reports. This because the application that it is for generates XML documents as output. Normally I have no problem loading the generated XML file into a dataset using the <Query><ElementPath>--data--</ElementPath></Query> syntax.
But now I have run into a problem I do not find a solution to. The generated XML (which I cannot change) uses a dot in the node names. What is the syntax I have to use to get the data out? I do not get errors when I try using it, but I also do not get any data shown.
For reference, here are some small examples with the XML file included:
The first one is how I have been doing it so far:
I get the data out of the XML file just fine using
Now my XML file looks like this (the only change is the . in the node name:
Now when I try writing a query to create the dataset like this:
I get no errors when looking at the report in Preview, but I also do not get any data back (and there is data in the XML file).
If anyone could help me out with this issue, I would really appreciate that.
Thank you for your question.
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.
Thank you for your understanding and support.
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.
I cannot reproduce your problem.
If you use this query like this, can it show data?
As suggestion also that you can update your SQL Server to latest Service Pack and CU.
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.