cancel
Showing results for 
Search instead for 
Did you mean: 

If.... then.... else on hyperlink

Former Member
0 Kudos

hi

i have a webi where i need to link two more reports based on if .. then ...else condition, here is my scenario,


Name    amount
A            100
B            200

I have to create to a hyperlink on name object, so it should link to the next report based on its cell value like,

if name = A then link Report2

if name = B then link Report3

Else link Report4

is this possible ?

how to get this in open document syntax ?

Regards

Dineshkumar

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos
Former Member
0 Kudos
=If [name]="A" Then "<a  href=http://yourservername:portnumber/OpenDocument/opendoc/openDocument.jsp?iDocID=yourReport2Id&sWindow=New&sKind=FullClient>MyLink</a>"
 Else If [name]="B" Then "<a  href=http://yourservername:portnumber/OpenDocument/opendoc/openDocument.jsp?iDocID=yourReport3Id&sWindow=New&sKind=FullClient>MyLink</a>" Else "<a  href=http://yourservername:portnumber/OpenDocument/opendoc/openDocument.jsp?iDocID=yourReport4Id&sWindow=New&sKind=FullClient>MyLink</a>"

where yourReport2Id is the Id number of Report2, you can find it right clicking on Report2 to see its properties. There you can find wht's the numeric Id of the report.

Same applies to Report3 and Report4, you have to write down their Id numbers.

Former Member
0 Kudos

yourservername:portnumber

in the example replace these values with your BO servername:its port number. For example:

myServer:8080

Edited by: PadawanGirl on Apr 6, 2011 8:46 PM

Former Member
0 Kudos

I don't know the correct syntax for openDocument, I let you create them.

About the condition, in a column of the tab I should go like this.

if [mydimension] = "A" then "openDocumentLinktoreportA" else if [mydimension] = "B" then "openDocumentLinktoreportB" else "openDocumentLinktoreportB"

I think you should right click your cell and select "HTML text" in the properties.

I prefer to use alterters for colors and format a text.

Former Member
0 Kudos

Try to apply alerter here Name = A than in formate paste the hyperlink for report Report 2

In the same alerter now add another Alert

Name = B than in formate paste the hyperlink for report 3

now add another subAlert

Name "Not in List A and B han in formate paste the hyperlink for report 4

Whenever you click on any value in the Name column it will open the respected Report.

Try this hope this will work out for you.