how to display the xml data returned by wcf service with ssrs

Posted by Praveen7k under WCF on 9/16/2011 | Points: 10 | Views : 3341 | Status : [Member] | Replies : 3
i have a wcf service returns that returns an object that contains the data in xml like below..have to display with ssrs dataset as the xmldatasource ..connection string is the service url

My xml looks like this.

In the query designer ..how to write the query

For this XML what should be the element path like? Please let me know..




Responses

Posted by: Vishvvas on: 9/16/2011 [Member] [MVP] HonoraryPlatinum | Points: 25

Up
0
Down
If I understood correctly
1. You have WCF returning XML
2. This XML shall be displayed as XMLdataset with SSRS

Yes, its feasible. The xml data provider can be used in this scenario. Following steps can be useful
1. Report designer --> new Report Server Project
2. New project--> blan report-->"Data" tab-->select "new dataset"--> choose xml as type
3. in coonection string, give the URL .
and follow the next steps.

Hope this helps.


Praveen7k, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Praveen7k on: 9/16/2011 [Member] Starter | Points: 25

Up
0
Down
i tried this way..http://msdn.microsoft.com/en-US/library/aa964129(v=SQL.90).aspx

can u tell how the query should look?







Praveen7k, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 9/16/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
I remember i wrote an article on how to consume rrs feeds in asp.net just look at it
http://www.dotnetfunda.com/articles/article731-how-to-consume-other-sites-rss-in-aspnet-.aspx



Thank you for posting at Dotnetfunda
[Administrator]

Praveen7k, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response