Scheduling reports

  • Thread starter Thread starter Randy K.
  • Start date Start date
R

Randy K.

I have several reports that take > 30 minutes to run and would like to have
them run at night and be ready when staff comes in for work. I have a
machine that runs 24/7 to use and have seen code to use vbscript and 'at' to
do this. BUT, most of these reports use queries that use global variables
as criteria (the globals get set by controls on several forms and/or
functions that get called when changing a value on a form) and I have yet to
get it to accept values at runtime so the report always comes out blank.
How do I set global variables via vbscript OR another way of using my
existing .mdb (I don't want to have to make another copy using different
criteria style) to schedule the running of reports. I have VB6/VB.NET
available to me as well.

TIA,
Randy K.
 
Sounds like you would need some code to run to set the variables before the
code runs to create the report.

You could checkout our batch reporting module as some example code you could
use that would get
you most of the way there to create PDF files during the wee hours of the
night.

I could look at it if you need some help,
Mark
RPT Software
http://www.rptsoftware.com

PS: Just send an email to the support@ address on our web site if you want
me to take a look
and give you an example if it's not too much work.
 
Not quite what I am looking for I don't think for couple of reasons:
1. I actually want the reports to print to a printer (for mailing)
2. I am looking for the answer to your first comment. I know how to
schedule them, I just can't get the variables set when it runs.

Randy
 
Back
Top