Re: Help - formtting report base on sign in id

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 22 Sep 2004 16:20:10 -0400
Message-ID: <tMudnTILXsMOQ8zcRVn-tQ@comcast.com>

" MoonWaker" <Moonwaker_at_hotmail.com> wrote in message news:tfk4d.18551$pA.1252577_at_news20.bellglobal.com...
| Hi...
|
| How to display the number into different currencies based on the sign-in
ID
| in Oracle reports.
|
|
| Thanks
|
|

you'll have to design and code it, there's no single currency conversion function in oracle...

how are you running oracle reports (report server on the web or client/server)? how are you authenticating users? that will determine how you can tell one user from another -- then, you'll need to know which currency the user should see (should be in come configuration table in your application, and call a conversion routine to convert to the correct currency

++ mcs Received on Wed Sep 22 2004 - 15:20:10 CDT