URLEncoding in links in Report Services v1

[AndyH1]

I'm using Reporting Services v1 developing the reports in Business Intelligence Studio 2005
Im trying to modify a link in a report passing parameters, that was originally a Link to subreport and need to do it as a Link to URL
However I'm having issues with the parameter passing

The link to URL field is something like
="

http://mysite.com/Login.aspx?Date="

+ TheDate.Value

However I believe the link is failing, I believe because I'm not urlencoding the date value and the /s are messing it up. theres also issues with other parameters and I need to urlencode those too

I can't however figure out the function to URL Encode it such that report writer will recognize the function. Ive tried:
HttpUtils.URLEncode(),Utils.URLEncode(), Server.URLEncode()
but it doesn't seem to recognize any of these.

Looking at the lists of functions and routines there doesn't seem to be one in the lists that does a URLEncode

Could people advise me which I need to use or do. Is there a way of including libraries in the report for example?

Thanks
Andy

 

[AndyH1]

Ive tried adding a reference to System.Web (cant see one for Server) and then using

Public Function Encode(txt as String) as String
Return HttpUtility.UrlEncode(txt)
End Function

Also tried Srrver.UrlEncode

frankly I'm a bit stumped - can anyone help - it seems this would be a common thing too do (URL Encoding the variables) and I muss be missing something?

Thanks
Andy