Cognos with Sharepoint

[Kanag]

Hi guys,
               Could you please help me to know how to use the hyperlinks in Cognos.

My requirement is as follows:

1. We have a cognos report with a hyper link in it.

2. We need to traverse to the sharepoint from cognos report

3. The sharepoint URL is available as a column in a database table

4. We can pull that column in the report and when we click on the link , it should go to the Sharepoint portal

Above are my requirements ...

Please let me know the steps to do the above...

I am new to Cognos..any help is much appreciated

Thanks,
KR

[MFGF]

One option is to drag the column in, then use html items before and after the value to construct an anchor tag.  You may have to unlock the structure of your list to drop these inside the column.

Regards,

MF.

[bdbits]

You can drag a hyperlink from the toolbox tab in the Insertable Objects pane. There is a hyperlink property with a dropdown called "Source Type". You can change this to use a data item - e.g. your column - or use an arbitrary report expression.

[Kanag]

Thanks a lot for your help. Let me work on that and post if there are any queries still :)

Regards,
KR

[Kanag]

Hi MFGF,
                Thanks for ur reply!

It would be great if u can explain me how to create an anchor tag with one example..


Regards,
KR

[Lynn]

The syntax of an anchor tag is roughly this:

Code Select Expand

<A HREF="www.google.com">Click Here to visit Google</A>


In your case I believe you can construct a data item in your query that contains the full tag by pasting together text and the URL contained in your database. Then use this as the source for the HTML item in the layout.

Otherwise, you can just drag the data item containing the URL into the layout and then put an HTML item with text before that item (it would contain the <A HREF=" portion) and then put another HTML item after it containing the remainder of the text ( "> Click Here etc. </A> )

[Kanag]

Lynn, Thanks a lot !!

Regards,
KR