opendocument error

Hello,
I was linking two reports using opendocument which was working very good in most of my reports but the when i try to implement that in one of other reports i was not able to see the hyperlinks instead #ERROR was being displayed in the cells. I am attaching a screenhot and also the code of this opendpcument.
Thanks,
Trex

="<a  href=/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sType=wid&amp;sRepoType=0&amp;sDocName=IPaddress+360&amp;sRefresh=Y&amp;lsS"+URLEncode("UserID")+"="+[UserID]+"&amp;lsS"+URLEncode("Begin_Time")+"="+URLEncode(UserResponse("Begin_Time"))+"&amp;lsS"+URLEncode("End_Time")+"="+URLEncode(UserResponse("End_Time"))+">"+[UserID]+"</a>"

errror.JPG


trex_bo :us: (BOB member since 2006-08-27)

Comparing with the syntax that works on our reports, you may need a [b][/b] and an extra double quote at both ends of the URL. Try something like this:

="<a href=\"/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp? ... +"\">"+[UserID]+"</a>"

Good luck,

Jim


JimBuckRG :us: (BOB member since 2006-07-17)