sql server reporting services: Hello,

I have a application that stores most of the data that need to be
analized in Xml, in a text collum.
I would like to know if there is a way that the reporting service consume
this
datasource to create the reports.
I have the intention to migrate to SQL 2005 and put all the Xml data in a
Xml datatype collum, so using SQL 2005 is not a problem.

RS 2005 will provide a new Xml data extension out-of-the-box which can
retrieve xml data through SOAP or HTTP. It will also allow to decode Base64
or Html encoded contents within Xml documents on-the-fly.

For RS 2000, you would need to implement your own custom Xml data extension.
I know some people have done this, but I'm not sure if anyone has shared
their xml data extension implementation on the web.

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



"Geraldo Thomaz Jr." <GeraldoThomazJr@discussions.microsoft.com> wrote in
message news:A8FA24E1-5F6B-471C-949E-3B280BA3BCF6@microsoft.com...
[quoted text, click to view]