| Fetching Reports through Forms [message #321066] |
Sun, 18 May 2008 22:00  |
g.s1223
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  |
 |
djmartin
Messages: 10181
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.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
