CODEWITHSUNDEEP
xmlsql-server-2005reporting-services
abramlimpin
abramlimpin

Reputation: 5077

How to create reports in SQL Server 2005/2008 Reporting Services using XML data?

Any suggestions on how to create report/s in SQL Server Reporting Services using XML data (found in existing table/s)?

Upvotes: 2

Views: 2524

Answers (2)

Denis Valeev
Denis Valeev

Reputation: 6015

It's actually easier than you might've originally thought.

  1. Create a stored procedure that shreds the xml and outputs the underlying info in a nice tabular form.
  2. Process this data in SSRS using this stored procedure as data source.

Read about xml shredding here: XML Support in Microsoft SQL Server 2005

Upvotes: 1

Sidharth Panwar
Sidharth Panwar

Reputation: 4654

I'm not an SSRS expert but from what I understand I think you might need to create the xml first before and use the XML data source to create your data set. So basically, I'm suggesting a two step process. Export the data to an xml file from Sql Server in step 1 and in Step 2 use the XML data source type to connect to the xml file and generate the SSRS report.

If you directly connect to Sql Server through SSRS, you'll get raw xml data with all the tags and everything and I don't think SSRS will allow you to (programmatically or otherwise) display this raw xml data in proper format.

Upvotes: 1

Related Questions