Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help - formtting report base on sign in id

Re: Help - formtting report base on sign in id

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 22 Sep 2004 22:26:17 -0400
Message-ID: <HrGdnb1wxsr3qc_cRVn-gQ@comcast.com>

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:Xns956CB5F492AE6SunnySD_at_68.6.19.6...
| " MoonWaker" <Moonwaker_at_hotmail.com> wrote in
| 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
| >
| >
|
| Use a LOGON trigger & a lookup table to feed an ALTER SESSION command

i believe we're sharing sessions under SSO (see OP's follow-up) so the LOGON trigger wouldn't work -- but the same concept would work in a report 'before-report' or 'after-parameter-form' trigger (forget which, but it's in there)

i think you're getting at changing the NLS parameters -- but that just changes the currency symbol, it does not do the currency conversion

so by using formats with the NLS currency symbols and thousands separators (instead of '$' and ',') these would be affected by NLS settings, but the value returned would need to be converted from the database currency to the user's currency -- hence, the need to return the value to the report via a conversion function that is aware of (or is passed) the user's currency

++ mcs Received on Wed Sep 22 2004 - 21:26:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US