Is automated export to Crystal possible?

[etienne123]

When a report is run (over a Crystal report viewer) (Crystal v8.0), is it possible to automatically create a Excel version (automated export to Excel)?

Etienne

 

[dgillz]

I do not think so, however there are a number of third party products that can do this. Check out

http://www.milletsoftware.com

and

http://www.chelseaeh.co.nz.

Both are active members of this forum and have good crystal reports scheduling products with export capabilities.

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[craigber]

Yes, you can do this. Before the code to display the report in the Viewer, you can set the properties of the Export object in the RDC then call the Export method.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[chelseatech]

Just a correction to dgillz's link above - my web site is

http://www.chelseatech.co.nz

(I think they spell things differently in Alabama)

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[IdoMillet]

Etienne,

It sounds like you don't want to use another tool to view or schedule the report, but to cause an automatic export to Excel each time the user views the report (in Crystal or in your existing viewer).

If this is indeed the case, you would need to buy (or build your own) User Function Library (UFL) that causes an export to occur when a formula gets "evaluated" within your report.

My "CUT" User Function Library provides this functionality, and there may be other candidates in the listing of 3rd party tools provided by Ken Hamady at:

http://www.kenhamady.com/bookmarks.html

Cheers,
- Ido

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

http://www.MilletSoftware.com