hyperlinks question

building reports desktopintelligence
1

Hi,

Currently I have a cell with a hyperlink set up as follows:

Click here for definitions

The location of the definitions.html changes, so I’m trying to figure out the best way to do this, without manually changing each cell on each tab of the report.

I created a table in the database to hold this and some other values.

If I pull the url field from the database, how would i implement this into the hyperlink mentioned about. I tried:
<a href=<URL_Obj>Click here for definitions. Didnt work.

Anyone have any ideas.

Thanks so much for any help.

-tiggz

tiggz82 (BOB member since 2005-05-05)

2

Try this - this works for me:

Instead of the double-quote symbol ("), you must use the function CHAR(34). The number 34 is the ASCII code for the double-quote symbol.
3. Build a formula that will give you the correct HTML syntax:

Value displayed

For example, to display the PDF report based on the name object:

="<A HREF="+Char(34)+“path:\ “+()+Char(34)+”>”++ “”

Where:

  • “path:” is the targeted server
  • “” is simple text pointing to the correct path for each value in database
  • “” is the name in the database

For example, the result for the name object “Seb” will be:

=<A HREF=“path:\results\marketing\sales\reportseb.pdfl”;> Seb

The name will be displayed as a hyperlink in BusinessObjects.

Note: These hyperlinks will also work in WebIntelligence reports.

Intelligentsia :australia: (BOB member since 2005-06-07)

3

Awesome. THanks. THis works.

Ok now the problem I’m having is getting this to show up in a cell or in a column heading. I get a multivalue error everytime i put the formula in.

THe formula is:
="<a href=" & Char(34) & <STRING_VALUE> &"#RTK" & Char(34) & “>”&“RTK Definition” &""

Any idea as to why this is happening. There’s only one row of <STRING_VALUE> in the data provider. So, I dont know why I would get a multivalue error.

Thanks for any help!

tiggz82 (BOB member since 2005-05-05)

4

I’m not sure why multivalue error is coming. But you can use Max or Min function as a workaround. Hopefully that will eliminate it.

salam :pakistan: (BOB member since 2005-01-27)

5

Hi there,

this is weird, … try to put a Multicube() …that may help…

Cheeers

c

Intelligentsia :australia: (BOB member since 2005-06-07)