COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: nsaxena on 30 May 2017 05:39:37 PM

Title: how to add hyperlink (path to cognos report) in report schedule email under body
Post by: nsaxena on 30 May 2017 05:39:37 PM
hello All,

i want to add hyperlink to cognos report schedule email under body

something like this(content of body) : click here if you want to see the report with other options.

now i want when this mail line goes to user, 'here' word should be hyperlinked with path to report.

I do not want share full URL

Any options. thanks!
Title: Re: how to add hyperlink (path to cognos report) in report schedule email under body
Post by: New_Guy on 30 May 2017 06:34:58 PM
Hi,
Send the report in HTML and add a hyperlink in the report and render it for HTML output format and add the report url as a source that you find in report properties and rename the default text as 'here'
Good luck
New guy.
Title: Re: how to add hyperlink (path to cognos report) in report schedule email under body
Post by: nsaxena on 31 May 2017 10:34:46 AM
thanks for replying. i do not want to send the report output as HTML.

There is specific business reason for that. We want to share output as attached excel output. Not we want to include report path link in body of it so that  in case some report users want to additionally play with report filters and run, they can open .

hope you understand. Thanks!
Title: Re: how to add hyperlink (path to cognos report) in report schedule email under body
Post by: New_Guy on 31 May 2017 02:29:43 PM
Hi
Attached report is the way we did it for a similar requirement. you have to schedule it to run it in both HTML and Excel. And need to hide a prompt from the users based on the group. Attached report has 2 pages and you can try doing it in one page.
I think you can you can also insert a link to a report using event studio and attaching the report output.

Good luck
New guy
Title: Re: how to add hyperlink (path to cognos report) in report schedule email under body
Post by: nsaxena on 01 Jun 2017 04:31:54 PM
hello thanks for input,

i figured out way and its working now... we are using HTML tags <HTML> </HTML> AND USING <a href= '' tag to embed link path to cognos reports in email body of report schedule.