Home > Archive > FoxPro database connector > April 2005 > VFP and windows sheduler









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author VFP and windows sheduler
news.spidernet.net

2005-04-21, 3:24 am

is there any way to shedule a report to run on a specific time?
i dont want to create un executable only for one report
i need the user to decide which report and what time to shedule and also
multible shedules for the same report


George Malekkos


Lee Mitchell

2005-04-21, 1:25 pm

Hi George:

Windows Scheduler will not run a report without VFP being installed or an
executable and the runtime files. So you need an exe in any case.

I suggest you create a form that collects the time and date the user wants
the report to run and then sets a timer in the application to print the
report at the appointed time.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>is there any way to shedule a report to run on a specific time?
>i dont want to create un executable only for one report
>i need the user to decide which report and what time to shedule and also
>multible shedules for the same report



>George Malekkos


Dan Freeman

2005-04-21, 8:25 pm

As Lee says, you're going to need SOMETHING for Windows Scheduler to run,
whether an EXE, BAT or CMD.

You could always write a simple program that accepts one parameter, the name
of the report:

lparameter tcReportName
REPORT FORM (tcReportname) TO PRINTER

and schedule that. <g>

And you can get as fancy as you like. You could create a report
configuration file, let the user set report parameters, and run your simple
exe (above) with the name of the configuration in that file.

Dan

news.spidernet.net wrote:
> is there any way to shedule a report to run on a specific time?
> i dont want to create un executable only for one report
> i need the user to decide which report and what time to shedule and
> also multible shedules for the same report
>
>
> George Malekkos



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com