question

desiabhi avatar image
desiabhi asked

The SSRS subreport will acquire xml value and produce the result in tabular format

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. It is very urgent please. Thank you so much for understanding my question and helping me in this regard.
sql-server-2005ssrssql-serverssrs-2005
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
KenAWatson avatar image
KenAWatson answered
In all my reporting, I have never had cause to use the XML data type in a report. However, I found this link that seems to give ideas on how to get started. perhaps it can get you going at least. http://stackoverflow.com/questions/6117688/does-ssrs-2008-support-the-xml-datatype-in-sql-queries Here is another article on this site that may spark some momentum. Perhaps you can cobble these ideas together to get to your solution: http://ask.sqlservercentral.com/questions/6452/how-to-query-xml-to-allow-ssrs-2008-usage-analysis
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.