question

reddy avatar image
reddy asked

How to display xml data fetched from db server to show on Reporting services(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. It is very urgent please. Thank you so much for understanding my question and helping me in this regard.
sql-server-2005ssrsssrs-2008ssrs-2005
10 |1200

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

1 Answer

·
Doug Lane avatar image
Doug Lane answered
Can you tell me exactly what the problem is? Is it a matter of rendering the XML in the subreport, or is the XML not getting passed correctly? If the XML is making it to the subreport, you just need to convert it to tabular format for the subreport to render.
10 |1200

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.