Convert XML to String with formatting

Recently I needed to display an XML column on SSRS report. XML has just few tags, but tags were different from row to row. I thought no problem, just include it to data set and add that field into table. But I was terribly wrong. It turned out that SQL server converts xml into a single line sting which is not readable as all, but I wanted present it nicely: something similar to how xml displayed in Management Studio, but without colours.

Internet search did not give me good solution so I decided to write own function which renders xml into text with each tag on separate line and proper indents. Below is the function I wrote. Hope it saves time to someone in similar situation.

Cheers,

Andrei