APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set number format in report.

581144Nov 26 2008 — edited Nov 28 2008

Hi guys,

I have a problem regarding the format of the number columns in my report.

I have a form in Oracle Applications where the user will enter some different information. When the user is done he/she clicks on the button “Generate report”. The button looks on the users input and generate a web address with the right parameter and opens a new window with the APEX report.

The parameter also contains the username, user id, etc.

Now; I want the number columns in the report to be in the format that the users have specified in their preferences (NLS_NUMBER_FORMAT).

My idea was to use the APEX_CUSTOM_AUTH.POST_LOGIN to login the user. Execute the query and then receive the right number format. Would that even work?

When I try to use the APEX_CUSTOM_AUTH.POST_LOGIN I get the “Page cannot be found” error.
Is there a better way to accomplish my goal?

Thank you in advance
Kenneth Kristoffersen

This post has been answered by munky on Nov 27 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2008

Added on Nov 26 2008

#apex-discussions

8 comments

1,014 views