Hyperlink syntax

building reports webintelligence
1

friends i am trying to create a hyperlink but getting errors. Any advise is appreciated. Please find along the syntax i am using on BO XIR2.

="<a href=“http://servername/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDoc=”+"&iDocID=122198&sWindow=New&sRefresh=Y&sType=wid"+"&lsS" + (“1. Enter Fiscal Year (Format: YYYY)”)+ “=” +[Budget Fscl Yr]+"&lsS"+(“2. Enter Pay Period (Format: PP)”) + “=” +[Current Pay Period]+"&lsS"+ (“3. Enter Calendar Year (Format: YYYY)”) + “=” +[Pay Prd Calendar Yr]+"&lsS"+ (“4. Enter Project Code”) + “=” + [Project Code]+ “”>"+[Project Desc]+""

alexks (BOB member since 2008-03-25)

2

Either use sDocName or iDocId
URLEncode everything that has a possibility of non-URL safe characters,e.g. spaces, &, [,], etc.

Try this:


="<a href=\"http://servername/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?iDocID=122198&amp;sWindow=New&amp;sRefresh=Y&amp;sType=wid&amp;lsS" + URLEncode("1. Enter Fiscal Year (Format: YYYY)")+ "=" +[Budget Fscl Yr]+"&amp;lsS"+ URLEncode("2. Enter Pay Period (Format: PP)") + "=" +[Current Pay Period]+"&amp;lsS"+ URLEncode("3. Enter Calendar Year (Format: YYYY)") + "=" +[Pay Prd Calendar Yr]+"&amp;lsS"+ URLEncode("4. Enter Project Code") + "=" + [Project Code]+ "\">"+[Project Desc]+"</a>"

Farhan Jaffery :us: (BOB member since 2005-08-27)