Using a Dynamic XML Dataset

Is there a way to dynamically use an XML dataset as a datasource?
[65 byte] By [KimberlyL] at [2007-12-24]
# 1
Xml Data Provider. It can make SOAP call or use URL to get xml data, then parse it and flatten into columns and rows.
AlexandreMineevMSFT at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
Thank you for your response. How do you parse it and flatten it into columns and rows?
KimberlyL at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3
We provide a primitive query language (Query/ElementPath) that you can use to define which elements represent rows and what should become columns.
AlexandreMineevMSFT at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 4
We got it to work. The problem that we are having is when multiple rows are returned in the dataset, it will not display them on the report, even though there is not a first wrapped around the Fields!whatever.value, the report is only displaying the first value that comes back.
KimberlyL at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 5
Could you bring here and example of xml document and the query? I will try to figure whats going wrong :)
AlexandreMineevMSFT at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 6
We got it fixed. Thank you very much, I appreciate your help.
KimberlyL at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified