Home » Developer & Programmer » Reports & Discoverer » how can we display User ID on Report?
how can we display User ID on Report? [message #415215] Sun, 26 July 2009 07:17 Go to next message
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
Re: how can we display User ID on Report? [message #415219 is a reply to message #415215] Sun, 26 July 2009 08:58 Go to previous messageGo to next message
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
Re: how can we display User ID on Report? [message #415229 is a reply to message #415219] Sun, 26 July 2009 10:08 Go to previous message
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:
  


Current Time: Thu Mar 28 07:50:17 CDT 2024