Home » Developer & Programmer » Forms » Fetching Reports through Forms (Oracle Forms 10g,Reports 10g)
Fetching Reports through Forms [message #321066] Sun, 18 May 2008 22:00 Go to next message
Messages: 17
Registered: May 2007
Junior Member
Hello everybody

I have designed this form for running a report.For his the data for the report is generated from a temporary table(not a global temporary table).I have to make a presentation on my work and I dont know know who created the reports.So, I wanna know why the data in the reports is from temporary table.

What I mean here is that I have created the data for the report to be genereated in my form itself and stored it in a temporary table.All the report does is fetches the data from the temp table.
Can some one tell me why the data is stored in a temp table(whats the use ,its advantages in short).Usually the data is fetched fron the report through a main query,isnt it?(Imean to say the report fetches the data through some query and does not depend upon the form to fetch the query)

With Warm Regards
Re: Fetching Reports through Forms [message #321324 is a reply to message #321066] Mon, 19 May 2008 21:14 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I believe that the following is obvious, but that you may have missed it.

As far as I am concerned the reason that you have written the form to populate a 'temporary table' is because you have been instructed to use an existing report and it expects to read the data, in a prescribed format, from a table and the designer of the report decided to use a temporary table.

We would use a permanent table so that the report could be rerun without re-extracting the data.

If you want to know why the report was written this way then you will have to talk with the programmer who wrote the report and possibily the designer who told the programmer to write it that way.

Previous Topic: Dynamic parameters
Next Topic: WHEN-MOUSE-DOUBLE-CLICK in a non database block
Goto Forum:

Current Time: Sun Aug 20 03:06:54 CDT 2017

Total time taken to generate the page: 0.09706 seconds