OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » How can i do this

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

How can i do this [message #218092]

Tue, 06 February 2007 15:09

chmlaeeque
Messages: 59
Registered: September 2006

Member

hay,
how can i save the report output, contains on several pages to a newly created table

Report message to a moderator

Re: How can i do this [message #218357 is a reply to message #218092]

Wed, 07 February 2007 18:59

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi,
I think you want to save the report output into a table. So one way is to save the output as RTF and load data into the table from the .rtf
Ashu

Report message to a moderator

Re: How can i do this [message #218400 is a reply to message #218357]

Thu, 08 February 2007 01:17

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, why would you run a REPORT in order to STORE its output into a TABLE? Why don't you, instead, simply run an ordinary

INSERT INTO newly_created_table
  (list_of_columns)
  (your_report_SELECT_statement_here);

Report message to a moderator

Re: How can i do this [message #218770 is a reply to message #218400]

Sat, 10 February 2007 00:11

chmlaeeque
Messages: 59
Registered: September 2006

Member

thanx for reply but can u explain it in detail that where i can write this code for my required purpose means in which trigger. or of report or form.
M. Laeeque

Report message to a moderator

Re: How can i do this [message #218862 is a reply to message #218770]

Sun, 11 February 2007 12:26

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Anywhere, as far as I'm concerned. I'd do it in SQL*Plus, but I guess your end-user wouldn't like that option. Form? Why not? Report trigger (AFTER PARAMETER FORM, perhaps?) Why not?

It doesn't really matter - I just wanted to say that it doesn't make much sense running a report and the result is not a printed paper, but bunch of records in a database table. There must be another way to do that, besides running a report.

Report message to a moderator

Previous Topic:	customizing the Discoverer viewer
Next Topic:	Calculation based on a field containing data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 04:47:28 CDT 2024