COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: tm1ist on 07 Oct 2015 02:27:56 AM

Title: How to show live exchange rates in Active Report?
Post by: tm1ist on 07 Oct 2015 02:27:56 AM
Hi all,

I have a requirement that particular current exchange rates (USD, EUR etc.) should be shown in an Active Report. Has anyone achieved this functionality?

I would prefer getting the numbers and format them myself. I guess there is only two ways to get the numbers:
(i)using some external url on the internet as a datasource in framework manager and creating&publishing that package to Cognos BI
(ii)using 'HTML Item' or similar item in the report to get the number from some service/website etc. somehow

Does anyone of you have any idea?