Skip to Content
0
Former Member
Mar 04, 2009 at 03:17 PM

Hyperlink Formula Correction

36 Views

Hi,

I use BOXI r2 sp4.

I have a crosstab report with 3 tabs. There is a prompt on the Billing Year Month dimension which is based on "between".

I would like to hyperlink from the Summary Tab to the Detail for One Server Tab.

I'm receiving an error message in my hyperlink formula listed below. The error message says, "Unrecognized input "\" at position 359.

Will someone please correct it?

>=If([Item]=" ";"https://reporting.corporate.ge.com/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?

iDocID=11387685

&sReportName=DetailforOne+Server

&sType=wid

&sRepoType=Corporate

&sWindow=New

&lsSBilling%20Year%20Month%20Start:="[Billing Year Month]"

&lsSBilling%20Year%20Month%20End:="[Billing Year Month]"

[Space] :blue: "\" :blue: >"[Cost of Service in US $]"";"https://reporting.corporate.ge.com/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?

iDocID=11387685

&sReportName=DetailforOne+Server

&sType=wid

&sRepoType=Corporate

&sWindow=New

&lsSBilling%20Year%20Month%20Start:="[Billing Year Month]"

&lsSBilling%20Year%20Month%20End:="[Billing Year Month]"\">"[Cost of Service in US $]"</a>")

Thanks!