Home » Developer & Programmer » Reports & Discoverer » Report LOG File..
Report LOG File.. [message #272092] Thu, 04 October 2007 00:40 Go to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

i want to create a report log file...
that at what date/time user run this report.
how to do this..?
Any idea

[Updated on: Thu, 04 October 2007 01:07]

Report message to a moderator

Re: Report LOG File.. [message #272141 is a reply to message #272092] Thu, 04 October 2007 02:10 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a table; for example
CREATE TABLE report_log
(report_name   VARCHAR2(30),
 user_name     VARCHAR2(30),
 last_run      DATE
)
Insert records into it in one of the Report Builder's triggers (for example, the AFTER REPORT one).
Re: Report LOG File.. [message #272161 is a reply to message #272141] Thu, 04 October 2007 02:38 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

ok
i will get date and time but how can i get report name ..
like report name is employee_salary
how will get that name of report in after parameter or after report.
Re: Report LOG File.. [message #272178 is a reply to message #272161] Thu, 04 October 2007 03:15 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Two possible options (as far as I can tell): first is to hard-code report's name (which is a stupid solution). Another one is to use the SRW.GET_REPORT_NAME built-in function.
Previous Topic: Crystal Reports Error ??????////
Next Topic: Problem with reports
Goto Forum:
  


Current Time: Sun Dec 04 08:53:15 CST 2016

Total time taken to generate the page: 0.23046 seconds