Auto Print Me!

[mission2java]

Hi,

We have a report for labor created by a contractor. Real nice report...however is it possible to have Crystal automatically print this report without manual labor? Like say every 5 days the report should automatically print without user intervention.

The second problem is this report takes 2 dates (parameters)
so can we still have it auto print and pass it two dates?

Thanks,
Jon

 

[crystalreporting]

There's a number of different ways to do this. Personally, I'd take a look at Ido Millet's Visual Cut application - it will allow you to schedule a report using the standard Windows scheduler, as well as some other neat functionality like bursting and emailing. I'd look at the date parameters in the report and see if I could do without them - I presume that if you want to run the report every 5 days, that you're probably running it for the previous week's info, so see if you can base the report's record selection on the current date. That way, once scheduled, the report would run automatically for the correct date range without the need for user input.

Peter Shirley

http://www.linkcorp.com

 

[mission2java]

Rather than looking at another application I was hoping to just write my own exe like in VB to do this...

however, my problem isn't opening the report in vb..its actually getting the report to print right away and the second issue is using the current date. How can I do something like this?

Thanks,
Jon

 

[dgillz]

How would you like to use the current date? In a record selection formula? Please give some examples.

Also, I second Visual CUT. Unless you have tons of time on your hands to recreate the wheel, or are independently wealthy and can afford to spend your own time on this, Ido's application is everything you want, at a very affordable price.



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

http://www.trianglepartners.com

 

[mission2java]

Its great you are offering his tool...
I have already created the VB app which is basically a crystal viewer and it pulls off the report. The only problem I am having is two things:

1) the print dialog box comes up...using the PrintReport method. I dont want that.
2) Ill have to figure out how to pass parameters.

Thanks,
Jon

 

[IdoMillet]

Jon,

The way to avoid the print dialog is to use:
-------------------------------
Report.PrintOut False
-------------------------------

You pass parameters using expressions such as:
-----------------------------------------
Report.ParameterFields(1).SetCurrentValue ...
-----------------------------------------

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[mission2java]

Yep got it!! Was using the wrong method..tried printout and it worked.

Thanks,
Jon

BTW: is visual cut in VB? It looks like it...Ive done something very similiar...I should start charging 225 bucks for it too!