Hi all, when I first learned about the ability in SQL Server 2005 Reporting
Services to use a Web Service that returns an XML Data Set as the Data Source
I was thrilled.

However I am having a small but very frustrating problem. I have a number
of Methods in my web service and all but one return only one value. It is
the one that returns multiple values that I am having a problem with.

It is trying to return exactly 200 fields (no I did not design the
database). When I run the DATASET from the Data Tab indeed I do get the
fields back with values in them. However the only field available for me to
select from is 'xmlns' which I cannot do anything with in my report. So this
particular DATASET is useless to me. But it is the most important set of
information I need to create my report and the report is meaningless without
it.

Does anyone know how to get the fields to generate? Yes I have tried
hitting the refresh button many, many times.

--
Thank you,

Hello John,

Thank you for your post in MSDN newsgroup!

I understand that you want to return muliple fields via XML data source but
it does not work as expect.

You may want to refer to the following links regarding the usage of the
XmlDP extension:

- Using the XML Data Extension to leverage an ADO.NET dataset in your SQL
Reporting Services Report:
http://blogs.msdn.com/bimusings/archive/2006/03/24/560026.aspx#565281

- Element Path Syntax:
http://msdn2.microsoft.com/en-us/library/ms365158.aspx

If you still encounter issues, please provide us a simple example, so that
we are able to reproduce the issue on our side. We look forward to your
reply.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks, that did indeed help it appears that I needed to use the Element Path
Syntax.

--
Thank you,
John


[quoted text, click to view]