Multiple OpenDoc URL’s or Reports in SAP BO Web Intelligence using hyperlink

If you use hyperlink wizard to convert a URL to a dynamic hyperlink in Business Objects WEBI report then it would point you to same url (or WEBI Document) with different parameter values but you get into trouble when you want different url’s or webi reports on the same column based on some value. (i.e clicking on each link should take you to different WEBI reports or  OpenDoc URL’s)

You can achieve this by using If statement in Variable.

ex:

=If [UVCSNumber] = 1 Then “<a href=”+Char(34)+”http://www.google.com”+Char(34)+” style=”+Char(34)+”color:#CC0000;text-decoration:none”+Char(34)+” target=_blank >yahoo</a>” Else If [UVCSNumber] = 2 “<a href=”+Char(34)+”http://noreports.com”+Char(34)+” style=”+Char(34)+”color:#CC0000;text-decoration:none”+Char(34)+”target=_blank >noreports</a>” Else “<a href=”+Char(34)+”http://sap.com”+Char(34)+” style=”+Char(34)+”color:#CC0000;text-decoration:none”+Char(34)+”target=_blank >sap</a>”

 

 

 

Leave a Reply