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
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
Thank you so much Lynn....your procedure of linking to external website is really helped me.., it worked for me.
Thanks
KWAS04