CODEWITHSUNDEEP
sql-server-2005reporting-servicesssrs-grouping
desi
desi

Reputation: 476

How to display XML data extracted from db server to SSRS

I am writing a simple report in Reporting Services that displays data extracted from a single table. One of the table columns contains XML data, which I want to pass to the sub-report as a parameter. This sub report should render the values in normal tabular format.

Upvotes: -1

Views: 904

Answers (1)

mameesh
mameesh

Reputation: 3761

I would do this on the SQL side. The more you can do in SQL the better. Take the XML and parse it into whatever format you would like, then it will be much easier to work with in SSRS

Upvotes: 1

Related Questions