Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 xml datasource

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2014-12-17 : 08:14:19
Hello,
My stored procedure returns data in xml format.
The result of this sp varies depending on what parameters are passed to it.
Question:
How can the result of this sp which is xml be used in SSRS to populate the data on the report please?
Thanks

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-17 : 08:50:37
It can't. You need to shred the XML (see nodes() function and examples in BOL)
Go to Top of Page
   

- Advertisement -