Home » Developer & Programmer » Reports & Discoverer » How can i do this
icon2.gif  How can i do this [message #218092] Tue, 06 February 2007 15:09 Go to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
hay,
how can i save the report output, contains on several pages to a newly created table
Re: How can i do this [message #218357 is a reply to message #218092] Wed, 07 February 2007 18:59 Go to previous messageGo to next message
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
Re: How can i do this [message #218400 is a reply to message #218357] Thu, 08 February 2007 01:17 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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);
Re: How can i do this [message #218770 is a reply to message #218400] Sat, 10 February 2007 00:11 Go to previous messageGo to next message
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
Re: How can i do this [message #218862 is a reply to message #218770] Sun, 11 February 2007 12:26 Go to previous message
Littlefoot
Messages: 20891
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.
Previous Topic: customizing the Discoverer viewer
Next Topic: Calculation based on a field containing data
Goto Forum:
  


Current Time: Sat Dec 03 22:21:55 CST 2016

Total time taken to generate the page: 0.07047 seconds