How can I display a SQL Server XML column as hyperlink in SSRS?

Question

I have a XML column in SQL Server that is returned in my datasource used by a SSRS report. Is there a way to display a hyperlink in the SSRS report column that displays the XML in a new window when the user clicks on it?

I want a "cleaner" display of the XML data then dumping it out in the report column but I need the user to be able to view the full contents of the XML column if they want to. This would be very similar to how SQL Server displays XML column data in SQL Server Management Studio where you see some of the XML data and it is hyperlinked so you can click on it to view the full XML in a new window.

DoubleJ · Accepted Answer · 2014-12-26 15:03:08Z

1

I suppose you display the xml data in a textbox. I suggest that you create a second report in which the full xml is displayed. In your existing report you could add an "Action" on your textbox which refers to that newly created report. You can limit the size of the xml displayed in with the LEFT() function. You might need to convert the xml in a string first by using CSTR(). Unfortunately I do not have a SSRS here (not working on Boxing Day :-)) to test it out myself.

Hope this helps.

answered Dec 26, 2014 at 15:03

DoubleJ

263 bronze badges

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

Collectives™ on Stack Overflow

How can I display a SQL Server XML column as hyperlink 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