COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: COGNOSBC on 17 Apr 2013 09:15:28 AM

Title: How to add document as a URL in the report
Post by: COGNOSBC on 17 Apr 2013 09:15:28 AM
Hi, I have very simple report with

Member ID and Document ID.  Each member has a document in PDF some thing written in it.
I need to add that dodument as a URL link for each member. 

so I tried to create a sample report adding with Hyperlink object and provided URL path but when I run the report it is not showing any links. not sure why

Can I get any help

Thanks
Title: Re: How to add document as a URL in the report
Post by: RKMI on 17 Apr 2013 10:48:40 AM
Hi,

How is the hyperlink url linked to the member is it in the same query? Also you might want to see your text source of your hyperlink.

Just try a simple example drag a new hyperlink in text source enter google and url enter path http://www.google.com when you run the report the hyperlink should show up.

Coming to linking your hyperlink to a member in a query. create a data item with following 'http://<localurl address>'+[Member] so when the report runs you should see member id 123 and link path as http://...../member123.

Thanks,
RK
Title: Re: How to add document as a URL in the report
Post by: COGNOSBC on 18 Apr 2013 12:40:52 PM
Thanks for your replay RKMI. 

Can I drag a hyperlink into list.  I just added one list report and dragged the hyperlink into list and then provided following url path http://www.google.com.

it says no data dislpayed.

if I drag the hyperlink out of the list it is working.

Thanks,
Title: Re: How to add document as a URL in the report
Post by: RKMI on 19 Apr 2013 11:08:50 AM
Yes, you need one other data item to drive the column for the list report.

Thanks,
RK