Data Item Hyperlink

[wmackenz]

I am trying to create a report in which one of the data items is a hyperlink to a 3rd party website.  The text within the data item is the URL, but there is obviously no hyperlink to click on.  I would like to run the report, see that item for each record, and click on the link to go to the 3rd party site.  Is this possible?  Any help would be greatly appreciated.  I am on Cognos 10.1.1.  Thank you!

[Lynn]

Put HTML tags around the data item in the expression. Then put an HTML item in your layout and change the source type to refer to your data item.

For example:

'<A href=' + [yourdataitem_url] + '>' + [yourdataitem_label] + '</A>'

I think this is how you do it, but going by memory here which can be dicey at times :)


Sent from my iPhone using Tapatalk

[wmackenz]

Lynn,

With the exception of a slight modification, that worked.   Thank you so much!   For future reference, here is what I changed to make it work:

Instead of using the listed expression:

'<A href=' + [yourdataitem_url] + '>' + [yourdataitem_label] + '[/url]'

I changed a couple of the tags:

'<a href=' + [mydataitem_url] + '" target="_blank">mydataitem_Label</a>'

I then created a HTML Item that pointed to the corresponding Data Item URL.

[Lynn]

Very good! The target is a good addition.