Hello Folks,
I am a newbie to XML. I am trying to retrieve a dataset from web-service. I am not able to retrieve the exact path to display the dataset in SQL Server Reporting Services. Here I am attaching the link which I am trying to implement. Everything is working fine, except I am not able to figure out the below part:
<ElementPath IgnoreNamespaces="true">GetTerritorySalesResponse{}/GetTerritorySalesResult{}/diffgram{}/NewDataSet{}/TerritorySalesYTD{TerritoryID, Name, CountryRegionCode, SalesYTD}</ElementPath>.
I tried applying the same way as explained, but it is not working. Can anyone please explain how to construct the Element Path?
Thanks in advance.
SammieRS
SammieRS.
I am a newbie to XML. I am trying to retrieve a dataset from web-service. I am not able to retrieve the exact path to display the dataset in SQL Server Reporting Services. Here I am attaching the link which I am trying to implement. Everything is working fine, except I am not able to figure out the below part:
<ElementPath IgnoreNamespaces="true">GetTerritorySalesResponse{}/GetTerritorySalesResult{}/diffgram{}/NewDataSet{}/TerritorySalesYTD{TerritoryID, Name, CountryRegionCode, SalesYTD}</ElementPath>.
I tried applying the same way as explained, but it is not working. Can anyone please explain how to construct the Element Path?
Thanks in advance.
SammieRS
SammieRS.