Home » Developer & Programmer » Reports & Discoverer » Display name of a user who ran the report
Display name of a user who ran the report [message #394058] Wed, 25 March 2009 10:17 Go to next message
dvbaskar
Messages: 5
Registered: March 2009
Location: UAE
Junior Member
i have some doubt in oracle reports

In my report under some text printed like

Thank you for using xxx
Documented prepared by GOPAL


for PREPARED BY whether he has to print the person who created the manifest
or person who is running this report.

user : bala
password : xxxx

then under the text the user name BALA is printed like this

Thank you for using xxx
Documented prepared by BALA.

HOW TO PRINT THE USER NAME IN ORACLE REPORT.TELL ME THE SOLUTION


[MERGED by LF]

[Updated on: Wed, 01 April 2009 13:00] by Moderator

Report message to a moderator

Re: oracle report [message #394353 is a reply to message #394058] Thu, 26 March 2009 10:10 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You could use SYS_CONTEXT - create a formula column and display it at the end of the report):

/forum/fa/5957/0/
report [message #394898 is a reply to message #394058] Mon, 30 March 2009 13:59 Go to previous messageGo to next message
dvbaskar
Messages: 5
Registered: March 2009
Location: UAE
Junior Member
one dooubt in oracle report 6i.

actually when logging the package and which user runthe report under the report the user name is printed.
ex:
thank for using llc company
prepared by XXXX

XXXX --> who is logging the report the user name will be printed.

how to set global parameter user_name in oracle report 6i.
reply me
Re: report [message #394907 is a reply to message #394898] Mon, 30 March 2009 16:28 Go to previous messageGo to next message
cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester
Senior Member
Littlefoot told you the answer to this here:
http://www.orafaq.com/forum/m/394058/129190/#msg_394058
If that solution doesn't work for you, you should say why in that thread so we can come up with an alternative.
Re: report [message #395528 is a reply to message #394907] Wed, 01 April 2009 14:00 Go to previous messageGo to next message
dvbaskar
Messages: 5
Registered: March 2009
Location: UAE
Junior Member
I AM NOT GETTING THE RESULT.SO TELL ME ALTERNATIVE SOLUTION USING GLOBAL PARAMETER USER_NAME
Re: report [message #395604 is a reply to message #395528] Thu, 02 April 2009 01:06 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I AM NOT GETTING THE RESULT

What does that mean? Any error? If so, which one? If not, what is it, then?
Previous Topic: Lov-restricted report and parameter setting
Next Topic: Oracle Reports
Goto Forum:
  


Current Time: Wed Nov 27 03:52:25 CST 2024