COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: XcognosX on 08 May 2014 09:12:21 AM

Title: Link Lotus Notes email ids to a Cognos query item in a report
Post by: XcognosX on 08 May 2014 09:12:21 AM
We have a requirement that we need to click on a person's name in a Cognos report and then land on Lotus Notes email page that addressed to that particular user

Exact requirement is,

We have a list report that has employee names and sales amounts.
When a user clicks on a employee name, a lotus notes email should get opened

This is pretty similar to what we see in most websites. Users click on 'Contact us' link and it will automatically open a
your default email with receiver's email adress

Has anyone done this ? I appreciate any feedback

Thank you in advance 
Title: Re: Link Lotus Notes email ids to a Cognos query item in a report
Post by: MFGF on 08 May 2014 12:22:33 PM
Hi,

You can do this by adding a query calculation that takes the user's email address and prefixes it with 'mailto:'

Then add a Hyperlink object (from the toolbox) to your list as a new column. In the properties of the column, set the Source Type (under Text Source) to be Data Item Value and in the Data Item Value property directly underneath, select the calculated item. Make the exact same change to the Source Type and Data Item Value properties under URL Source.

Assuming Notes is the user's default email client, this will then result in a new message to the specified email address being spawned in Notes.

Cheers!

MF.