vinny.jus

 Profile Answers by vinny.jus Questions by vinny.jus

• Dec 9th, 2009

 

Using Html tags we can create links to websites based on Object values. This can be done from Designer, DeskI and WebI.

To do this let us take a company object,that has values Sap, Microsoft,Oracle and so on. In a report containing company object,when we click on company value it should take to the company website.

In Designer-->Open the universe-->In classes and Objects(select Object)-->
In the object properties-->Select area we can write the below formula:

{fn concat({fn concat('<A href='+ {fn char(34)}+'www.', Co.company+'.com'+{fn char(34)}+'>')}, {fn concat(Co.company, '</A>')})}

and Right click object and in Object format-->check read as Html.

The same result can be achieved from Deski by writing the below formula in fx of Country.
=Concatenation("<a href=" ,Concatenation(Char(34) ,Concatenation("www." ,Concatenation(<Company> ,Concatenation(".com" ,Concatenation(Char(34) ,Concatenation(">" ,Concatenation(<Company> ,"</a>"))))))))

Also remember to check the Read as html in Format cell.

We can also have an object/column that contains Urls, so that the formula contains less inner concat functions.