XML Datasource From Database Column in SSRS

Question

First, a little background: We have been using SSRS in LocalMode for processing. We have an Object Data Source we've been using. This Object is serialized from an XML column in the database.

We're now forced to move to Server Mode due to memory leaks in Local Mode. As such, I'm rebuilding the reports. The problem I've run into is that I want to pull the XML data out of the database as an object but can't seem to figure out how to do this. I know I could create a web service or URL to provide it to the SSRS, but I want to avoid this if possible.

Is there a way to pull an XML column from a DB Data Source and get all the elements of it as the "Fields"?

Dmitry · Accepted Answer · 2012-02-27 18:44:00Z

1

Are you asking how to query xml from on the SQL Server? There's plenty of query examples online. It still returns as a dataset but you can modify it in custom assembly to return a String that can become the query for your xml dataset inside the report.

answered Feb 27, 2012 at 18:44

Dmitry

1291 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

XML Datasource From Database Column in SSRS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related