Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automated Faxing of Crystal Reports

Status
Not open for further replies.

crystalreporting

Instructor
Feb 13, 2003
649
0
0
NZ
Thought I'd let everyone know of a solution we've been working with to automatically fax Crystal reports. About two years ago we had a request from one of our clients to automate the faxing of the sales order acknowledgments. They would take approximately 150 orders per day, then print order acknowledgements (using Crystal) each night for that day's orders. A person would then spend the best part of the following day faxing these to their customers. We were able to assist somewhat by including the fax number on the acknowledgement, and by grouping the report by customer (some customers had multiple orders).

We looked at a number of 'fax server' products and eventually settled on FaxWare - a product developed by a New Zealand company ( - it is a low cost (under $400) fax server solution that runs as a service and polls a nominated folder for faxes to send out. We then utilized Ido Millet's brilliant Visual Cut application ( via the Windows scheduler to automatically group, burst and export RTF files to the FaxWare polling folder. FaxWare interprets the RTF files and looks for an imbedded fax number - it then strips it from the document and uses the number to dial and fax the document. You can include other information that FaxWare will recongize like customer number and name.

FaxWare has a log file and client application that lets you check to see which files sent OK and which files failed - you can choose to resend the failed ones - and the log includes any other imbedded info (customer number and name) so it's easy to review faxes that were sent months ago - you can even view and print the actual RTF document that was sent. FaxWare can be configured to retry faxes that fail multiple times at differing intervals, and it can even be set to purge it's own log files.

The reason I'm posting this now is that we've had a couple of clients using this product for years and it's extremely robust and reliable - with no maintenance once it's setup and configured. I just installed this solution again on another site last week, and it's working seamlessly again. It's great to have found an automated faxing solution that runs under $500 (including FaxWare and Visual Cut). I'll gladly provide more info. if anyone is interested.

Peter Shirley
 
Does this product work with CR10....
We use a similar product (zetafax) but have not been able to get it to work since CR8.5/9.0.
I believe this is due to the unicode changes.


Lochbel
 
Yes, Visual CUT has 2 version: one that uses Crystal 8.5 and one that uses Crystal 9 runtime components. The Crystal 9 runtime components version runs Crystal 10 reports without any problems.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Dittos to everything positive that has been said about Visual CUT. I also have a couple of clients using this product to automate emails to customers. Basically they are in a real time shipping environment and they automatically email a shipping notification to their customers every 10 minutes.

Visual CUT is a great tool.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com
 
We use a simular product from called Report Scheduler.

We email all of our ack & inv automaticlly each night. quick easy and very painless !


Then at week & month end all of the recaps to our sales force are printed and email.

Very nice program !
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top