If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Link to the External Website

Started by kiran04, 21 Aug 2011 10:31:27 PM

Previous topic - Next topic

kiran04

Hi Al,
I have a requirement where I need to link a column to external website i.e., fedex website, ups website and if not both I need not goto any of the links. , 1.Here I have three conditions.
1. the column may contain UPS Number or
2. it may contain Fedex or
3. it may contain none of the both numbers
So depending on the number(Column) .I need to link to that respective website.
Any suggestions on this one.
thanks,
KWAS04

Lynn

You can create a query item that contains the URL and hyperlink markup, then use an HTML item to present it in your layout. If you need to produce PDF output you can use a Rich Text item instead of an HTML item (but use just the URL without the HTML anchor tags).

For HTML:

  • create a query item in your query that decides which of the two (or neither) sites to link to. sample below.
  • drag an HTML item from the toolbox into your list in the desired location
  • change the HTML item properties to specify source type as "Data Item Value"
  • change the HTML item properties to specify "Data Item Value" as the query item you created
  • when you run the report in HTML format you will see the hyperlink

Presumably you can enhance the URL to go right to the tracking page and include the number, so hopefully this gives you the basic idea to get started.

case [YourFieldThatIndicatesTypeOfNumber]
when 'UPS' then '<A HREF=http://www.ups.com>UPS</A>'
when 'FEDEX' then '<A HREF=http://www.fedex.com>FedEx</A>'
else 'No Link Available'
end

kiran04

Thank you so much Lynn....your procedure of linking to external website is really helped me.., it worked for me.

Thanks
KWAS04