I'm using a DataFormWebPart with an embedded SoapDataSource. The problem is that SoapDataSource needs to have the full url of the site (http://server/_vti_bin/Myservice.asmx) to work. This makes moving between servers very tricky, as I have to manually update the fields each time. Also as the site collection is to be extended into internal and internet zones this adds another wrinkle. So far I have tried, <% $SPURL:~sitecollection/...%> which does give me a relative URL, and plain ~site/~sitecollection are not replaced. Is there away to embed SPCurrent.Web.URL into the webpart that isn't discarded by SharePoint designer? What other methods are there?
I'm trying to avoid coding this (Which is easily done) so I can avoid adding complexity when none should be needed.