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

Posted by Praveen7k under WCF on 9/16/2011 | Points: 10 | Views : 5380 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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..

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

Latest Posts