I found this way to get the root site collection url into a DVWP
There are Global parameters available but you have to mess about with the bindings to use them.
So for this one you need
<ParameterBinding Name="RootSiteUrl" Location="WPProperty[RootSiteUrl]"/>
Then at the top of the XSL (make it global to all templates)
<xsl:param name="RootSiteUrl"></xsl:param>
Then in your XSL you can use it
<xsl:value-of select="$RootSiteUrl" />
That’s it. Well it worked for me, but SP2013 and designers is so damn flakey it might not work for you, this was done on a WPPage not a wiki page that causes all manner of hell using webpatrs in those things.
The correct format I believe is
Apparently there is no way I can post xml, I just mean the braces should be replaced by parentheses in the parameter binding.