sql server reporting services:
In SQL2005 you have far better handling of XML data. As you say, you
have an XML datatype which allows you to read and write XML as you'd
expect without "shredding". The SQL syntax for doing this is a little
difficult to decipher (well for me anyway!) but if you're handling XML
regularly, it may make more sense to you. The XML handling is
completely overhauled in 2005 so you need to study it in BOL or MSDN2.
I got a Microsoft book "Introducing SQL Server 2005 for developers"
free from MS as a beta testing present, which does explain it quite
well.
I guess RS can use the new XML querying syntax aswell because it's all
part of T-SQL.
Hope that helps a little.
Cheers
Chris
[quoted text, click to view] Don Miller wrote:
> I have an XML data source (validated with a Schema) that I'd like to
> store in SQL Server 05 as xml type (one for each user/customer). What
> I'd like to see with Reporting Services is that I could have a
> library of report templates, and using the same XML data source alone
> (without shredding), these templates would be filled automatically as
> requested by a customer (each template using different elements in
> the XML document) and exported as PDF files.
>
> Is this something Reporting Services can do? From my very preliminary
> research (my RS 2000 books, planned RS 2005 books TOCs and Indexes)
> it would seem that I would have to shred the XML, store it as
> relational data, and than use SPs to fill the report templates. I
> suppose the SPs can use the new XML functionality to create a result
> set but I would prefer to just hand the XML document to the template
> and have it automatically find and replace the requested data
>
> Am I missing something? Could anyone direct me to examples of how
> this could be accomplished?
>
> Thanks.
--
