OraFAQ Forum: Reports & Discoverer » how can we display User ID on Report?

Home » Developer & Programmer » Reports & Discoverer » how can we display User ID on Report?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can we display User ID on Report? [message #415215]

Sun, 26 July 2009 07:17

Sarah Aman
Messages: 80
Registered: July 2009

Member

Hi all
can anyone guide me how can we display user ID on report?

thanks in advance

Sarah

Report message to a moderator

Re: how can we display User ID on Report? [message #415219 is a reply to message #415215]

Sun, 26 July 2009 08:58

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

This is a report question so you should post in Reports section.

create a Formula column in the report. Change data type to CHAR.

write the trigger:

function CF_1Formula return Char is
v_user varchar2(20);
begin
  select user 
  into v_user
  from dual;
  return v_user;
end;

Create a field in report and point to the source of the field to this formula column.

Done.

regards,
Saadat Ahmad

Report message to a moderator

Re: how can we display User ID on Report? [message #415229 is a reply to message #415219]

Sun, 26 July 2009 10:08

Sarah Aman
Messages: 80
Registered: July 2009

Member

hi sir
first of all thanks alot,its working and displaying ID on Report.

sarah

[Updated on: Sun, 26 July 2009 23:36]

Report message to a moderator

Previous Topic:	Error to run report
Next Topic:	How to convert a report from American Letter format (216mmX279mm) to DIN A4 format (210mmX297mm)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 04:01:49 CST 2024