OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Report LOG File..

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

Report LOG File.. [message #272092]

Thu, 04 October 2007 00:40

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: Report LOG File.. [message #272161 is a reply to message #272141]

Thu, 04 October 2007 02:38

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.

Report message to a moderator

Re: Report LOG File.. [message #272178 is a reply to message #272161]

Thu, 04 October 2007 03:15

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Crystal Reports Error ??????////
Next Topic:	Problem with reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 19:45:37 CST 2024