Home » Developer & Programmer » Reports & Discoverer » Generate report to database table (Oracle report 11g)
Generate report to database table [message #520856] Thu, 25 August 2011 02:55 Go to next message
ator
Messages: 43
Registered: March 2009
Member
Hi,

i already tried to look around the web but i didn't found anything,
so I'm here asking for your help.

My question is: Is it possible to save a report directly in a table instead of the typically destination? (file, cache,...)

Thx in advance for your help Smile

Ator.
Re: Generate report to database table [message #521594 is a reply to message #520856] Wed, 31 August 2011 08:36 Go to previous messageGo to next message
Littlefoot
Messages: 21547
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, as far as I can tell.

Why would you want to do that, anyway? Data is already stored in tables, you just use Reports to fetch these data and display them in a pretty manner.

You could, though, take all report's SELECT statements, "convert" them into "INSERT INTO ... SELECT ..." ones and run that script. However, it could be tricky if you used formula columns, functions, etc.
Re: Generate report to database table [message #521612 is a reply to message #521594] Wed, 31 August 2011 09:29 Go to previous messageGo to next message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
I assume OP wants the pdf saved.
Re: Generate report to database table [message #522047 is a reply to message #521612] Tue, 06 September 2011 01:52 Go to previous messageGo to next message
ator
Messages: 43
Registered: March 2009
Member
I need it because our program makes a lot of journal and someone is looong. So instead to generate the pdf in a specific location on AS, i thougth it would be better if there was a way to save it directly on db. I will find a way around then.
thx Smile
Re: Generate report to database table [message #522050 is a reply to message #522047] Tue, 06 September 2011 02:23 Go to previous message
Littlefoot
Messages: 21547
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why not saving PDFs in file system? I suppose that it is easier to access them that way, than storing them into the database. Backup them using your operating system's backup utility, instead of Oracle's one (RMAN?).
Previous Topic: Text Field Not Wrapping Properly
Next Topic: What is best place for report?
Goto Forum:
  


Current Time: Wed Apr 01 06:52:20 CDT 2020