By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,692 Members | 1,498 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,692 IT Pros & Developers. It's quick & easy.

Append Data From Report

P: n/a
Running Ak2

Daily there is a report that is run where a summation of the detail records is
placed in the footer. Simple standard operation.

What I would like to do at the time the report is run is to take the controls
in the footer (rptSum1, rptSum2, etc.) and append them to an existing table
(tblHistory).

Can suggest the proper proceedure to accomplish this task?

Thanks in advance.

"And.... Exactly at which point did you consider this a good idea?"
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi Clint,

Storing calculated results in the database is not a good practice. Any time
you need that result set you can calculate it.

HTH
--
-Larry-
--

"Clint Stowers" <cl*******@aol.comNoSpam> wrote in message
news:20***************************@mb-m29.aol.com...
Running Ak2

Daily there is a report that is run where a summation of the detail records is placed in the footer. Simple standard operation.

What I would like to do at the time the report is run is to take the controls in the footer (rptSum1, rptSum2, etc.) and append them to an existing table (tblHistory).

Can suggest the proper proceedure to accomplish this task?

Thanks in advance.

"And.... Exactly at which point did you consider this a good idea?"

Nov 13 '05 #2

P: n/a
In article <zd******************@nwrddc03.gnilink.net>, "Larry Daugherty"
<La********************@verizon.net> writes:
Storing calculated results in the database is not a good practice. Any time
you need that result set you can calculate it.


If I could, I would. But the data source is constantly changing. The report
being run is a result values at that moment in time. What is desired is to
append specific fields of the report to a table so some history may be
retrieved at a later date.

I can create a table with the default values a bunch DSum statements (or some
other scheme) But thought it would be nice to tap into the report data in that
it already exists.


"And.... Exactly at which point did you consider this a good idea?"
Nov 13 '05 #3

P: n/a
"Clint Stowers" <cl*******@aol.comNoSpam> wrote in message
news:20***************************@mb-m01.aol.com...
In article <zd******************@nwrddc03.gnilink.net>, "Larry Daugherty"
<La********************@verizon.net> writes:
Storing calculated results in the database is not a good practice. Any timeyou need that result set you can calculate it.
If I could, I would. But the data source is constantly changing. The

report being run is a result values at that moment in time. What is desired is to append specific fields of the report to a table so some history may be
retrieved at a later date.

I can create a table with the default values a bunch DSum statements (or some other scheme) But thought it would be nice to tap into the report data in that it already exists.


Clint,
You might be able to do this through code attached to the OnPrint event of
the totals section of the report. I am not sure if OnPrint events can
perform serious work, but if so you would just need to execute an append
query to your totals table, using the values currently stored in the
totalling controls on the form.

If OnPrint does not let you do this, you might be able to do it in OnFormat,
but this has the problem that it may possibly be called multiple times if
the page formatter has to retreat for any reason.

HTH
Doug

--
Remove the blots from my address to reply
Nov 13 '05 #4

P: n/a
cl*******@aol.comNoSpam (Clint Stowers) wrote in message news:<20***************************@mb-m01.aol.com>...
In article <zd******************@nwrddc03.gnilink.net>, "Larry Daugherty"
<La********************@verizon.net> writes:
Storing calculated results in the database is not a good practice. Any time
you need that result set you can calculate it.


If I could, I would. But the data source is constantly changing. The report
being run is a result values at that moment in time. What is desired is to
append specific fields of the report to a table so some history may be
retrieved at a later date.

I can create a table with the default values a bunch DSum statements (or some
other scheme) But thought it would be nice to tap into the report data in that
it already exists.


In that case, Report_Close would be a good place to put the SQL for
your append query. I would put in a YesNo MsgBox that would give the
user the option of appending to tblReportSummaries or not. In
deciding what to save, keep in mind you'll need an interface form for
retrieving the information.

James A. Fortune
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.