Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

want to use SQL function that returns XML as datasource to SSRS report in 2008R2 Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2013 4:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 8:38 PM
Points: 3, Visits: 119
HI All,

I am trying to use a SQL function which returns XML as a datasource for an SSRS report 2008R2.
I am not sure how this is posible.
1. I have created SQL datasource since i need to execute the SQL function which returns XML
2. Next i have created a dataset with the above datasource, but the problem is here. I need the XML nodes to be recognised ad fields which is not happening.

Any suggestions or best practises please.

Regards,
Madhan
Post #1474337
Posted Thursday, September 05, 2013 8:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 26, 2013 2:15 PM
Points: 39, Visits: 75
Simplest way would be to use the For XML clause in your query. Persist the query to the file system. Now you can connect to this using Report Builder.

I do have an example in my recent book on SQL Server Reporting Service 2012 the details of which you can find here:

http://www.sys-con.com/node/2712920
or here:
http://hodentekmsss.blogspot.com/2013/05/contents-of-my-forthcoming-book-on-sql.html

The links in the book are presented here:
http://hodentekmsss.blogspot.com/2013/06/links-in-book-learn-sql-server.html
Post #1492022
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse