Create dynamic hyperlinks based on the rawdata

Hi all,

please help me cause I don't have the clue.
I've a report where I want to link the fileds of a certain column to an external site that has the record data as part of his url.

for example:

www.mysite<ROWATA>.com

as you can imagine the link should be different record by record.

Thank you in advance for the help.

Find more posts tagged with

Comments

vucciria

Hi, there must be something wrong in what I'm doing.
There is anybody who can help me?

thank you very much. Every help will be appreciated.

vucciria

Please if anybody could help I will thank him. It's realy important

thank you

jhelbling

Hi vucciria,

When you edit your datset, did you already try to use the "computed columns" functionnality in order to build your hyperlink with something similar to :

BirtStr.concat("http://",row["CUSTOMERNAME"],".com")

Hope it helps.

vucciria

Hi, thank you for the reply. Which data type should I use there?
I don't need the link directly in the report but the record should be hyperlinked to a site wich has the record value in the URL. Have I to set the column field as hyperlink?

Regards

jhelbling

Hello,

Ok I didn't understand what you needed. Effectively if you simply need to set a hyperlink on a cell you can then use the "hyperlink" functionnality.

When setting the URI, you have the possibility to use custom functions in order to build the URI.

Then again you will be able to use the following but this time without modifying the text displayed to the user : BirtStr.concat("http://",row["CUSTOMERNAME"],".com")

vucciria

Hi. Finally I solved in another way: 
 
<a class='bbc_url' href='http://www.birt-exchange.org/forum/designing-birt-reports/9266-formatting-web-hyperlink.html'>http://www.birt-exchange.org/forum/designing-birt-reports/9266-formatting-web-hyperlink.html</a> 
 
I've putted a text control on my column instead of a data one and used the indications contained in the link 
 
 
Anyway thank you for your precious help!