Home » Developer & Programmer » Reports & Discoverer » Create Report LOG On client PC
Create Report LOG On client PC [message #281171] Thu, 15 November 2007 23:42 Go to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

I want to create report log on text file.
like.

report name/time/date..

A single Text file will be created on each user pc.

How to do this?
Re: Create Report LOG On client PC [message #281184 is a reply to message #281171] Fri, 16 November 2007 00:31 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd rather create some kind of a 'report_log' table, such as
CREATE TABLE report_log
(rep_name   VARCHAR2(30),       -- report name
 date_rep   DATE,               -- date and time when the report was executed
 user_rep   VARCHAR2(30)        -- username of the user who executed this report
);
and store information about report execution in there (using BEFORE or AFTER REPORT trigger). Also, you'd need to create a report which would display such an information.

If you insist on creating a log file, no idea at the moment; I like my idea better.
Re: Create Report LOG On client PC [message #281185 is a reply to message #281184] Fri, 16 November 2007 00:38 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

i Am already getting log with this way as u doing.

But their is some requirement of what i asked.

If any idea do share?
Re: Create Report LOG On client PC [message #281197 is a reply to message #281185] Fri, 16 November 2007 01:34 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
When do you plan to create this log file? Every time report is executed? Once a day? Monthly?

Who should create it? Every user for him/herself, or do you want to create a job which will take care about it?

Could you explain the whole scenario (the way you imagine how it should be done)?

Finally, it's just me being curious: what will an average user do with a file which looks like

EMPLOYEES_REP/08:35:02/16.11.2007
Re: Create Report LOG On client PC [message #281201 is a reply to message #281197] Fri, 16 November 2007 01:44 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

let me tell you the scenario..

actually when i run reports on my system.

in reports destination directory.A reports name text file is being generated.which have information like.

Starting report in_trading [Mon Sep 17 10:00:42 2007] ...
REP-0110: Unable to open file 'C:\sa\intra_trading.rep'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'C:\sa\intra_trading.rep'.
End report intra_trading [Mon Sep 17 10:00:42 2007].
..
Starting report in_t [Mon Sep 17 15:47:22 2007] ...
End report in_t [Mon Sep 17 16:07:07 2007].
.

like this for each report.
but i don`t even know how this file is being created.
is it report builder functionality.if it is can it be done on other pc`s.

I clearly don`t know how this report text file is getting updated
each time.
thats what i want to know??
I think i am clear enough with scenario.
Re: Create Report LOG On client PC [message #281210 is a reply to message #281201] Fri, 16 November 2007 01:59 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid this is beyond my knowledge ...

It, however, *smells* like Reports' Server setup to me. Which "parameter" (or whatever) or "where" to set it - I really wouldn't know. Sorry.
Previous Topic: unable to extend description field on report
Next Topic: TO_NUM and error handling
Goto Forum:
  


Current Time: Thu Dec 08 14:42:30 CST 2016

Total time taken to generate the page: 0.09405 seconds