Re: Help - formtting report base on sign in id

> | How to display the number into different currencies based on the sign-in
> ID
> | in Oracle reports.

> 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

Reports going to run thru Oracle Portal..so it is going to use SSO to validate user Id same time Application have user access currency and currency rate table.Problem is how to change all the reports already in use to display sign in ID base currency

MW Received on Wed Sep 22 2004 - 18:03:59 CDT