Automatically Schedule and Run Reports 1

[MrTBC]

I am running Crystal v8.5 reporting from a Progress database.
I have eight reports I have to run on a weekly basis to report on incorrectly entered data that needs to be amended. I run these on a Monday to report on data created during the previous seven days (i.e. Monday to Sunday). These reports are never actually printed, I just export them to Word and then paste them into emails.
Six of these reports run fairly quickly but two are very complex and can take up to fifteen minutes to run. This is a pain and also effects other users of the database.
So:
What I would like to achieve is scheduling these reports to run automatically early on Monday morning before anyone starts work.
Please could someone advise as to the best way to achieve this. We sometimes have information entered over the weekend, so the queries will need to be run with the reports on a Monday.
The ideal would be if I could set this up so that they are all run and available by the time I get into work, and are ready either as .rpt files or even better have been exported into Word.

Thanks very much for any help you can give me on this guys.

 

[pgtek]

hi

You need a scheduler to do this

you could try using a batch file to do this
or crystal enterprise $$$$$$
or check with Ken Hamady on his website for 3 party software

cheers



pgtek

 

[IdoMillet]

Here's the link to Ken's Comilation of 3rd-party tools. Look at the "Report Managers" category.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kenhamady]

See the LINKS page of my site for the list of schedulers


Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[MrTBC]

Thanks very much everyone.

 

[jhermiz2]

You can write your own scheduler in vb as well.
This is the route I have taken and then simply include it in your windows scheduler as a task (allowing for date and time to process this).

If you need more help on this let me know.

Jon

 

[roswald]

Hey Jan,
I'm sorry to interrupt your thread MrTBC but I am interested in Jan's post about writing his VB scheduler for use in Windows as a task. If you see this post Jan I would really be interested in looking the the VB app if you'd be willing to share it.
MrTBC I use the Windows Task scheduler all the time to automate launching tasks from various software applications. If you are using a windows os, you may want to go that way. It's fairly easy to set up and can be found in the system tools folder.

Bob

 

[OU18]

Hi All,

I would also be very interested in the vb to schedule reports. That would be extremely helpful, espcially in an enviornment where purchasing new software is out of the question (like mine)

OU18

 

[dgillz]

Ido's Visual CUT is the best tool I have ever seen for this. Very reasonably priced as well.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com