OraFAQ Forum: Reports & Discoverer » Create Report LOG On client PC

Home » Developer & Programmer » Reports & Discoverer » Create Report LOG On client PC

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

Create Report LOG On client PC [message #281171]

Thu, 15 November 2007 23:42

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?

Report message to a moderator

Re: Create Report LOG On client PC [message #281184 is a reply to message #281171]

Fri, 16 November 2007 00:31

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

Report message to a moderator

Re: Create Report LOG On client PC [message #281185 is a reply to message #281184]

Fri, 16 November 2007 00:38

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?

Report message to a moderator

Re: Create Report LOG On client PC [message #281197 is a reply to message #281185]

Fri, 16 November 2007 01:34

Littlefoot
Messages: 21813
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

Report message to a moderator

Re: Create Report LOG On client PC [message #281201 is a reply to message #281197]

Fri, 16 November 2007 01:44

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.

Report message to a moderator

Re: Create Report LOG On client PC [message #281210 is a reply to message #281201]

Fri, 16 November 2007 01:59

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

Report message to a moderator

Previous Topic:	unable to extend description field on report
Next Topic:	TO_NUM and error handling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:45:00 CDT 2024