Automatically Export Crystal Reports with Schedule


We would like a reliable solution to automatically export a number of crystal reports on a schedule (around 50 to 70 reports). We have Crystal reports 2008 (V12.1.3) for SAP B1.

Some reports will need to be automatically run daily, some weekly and some monthly and saved into a network share. Also we would like to be able to automatically email some reports and need to be able to export reports into popular formats such as Excel and PDF. If the software is able to automatically perform other automatic network tasks such as running a programme this would be a bonus.

Any recommendations on any good software to do this would be great? Ideally we don’t want to need to create complex scripts.
Who is Participating?
musalmanERP ConsultantCommented:
You are right  When there are good soft wares available why do you write from scratch...

A very good automation software is CRD.

Just have a look on following Description::

CRD® is a Crystal Reports Scheduler that saves time and money by making it easy to automate Crystal reports. Crystal Reports distribution is easy. Just define single or packages of Crystal Reports®, schedule and run them automatically, and send the reports to print, fax, disk, ftp, sms or email in a number of standard formats. You can just "set it and forget it".

Check the Link ...
kevin1983Author Commented:
Thanks ill have a look, sounds good
A site with several other options

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.


I am currently evaluating CRD for my organisation with teh intent to purchase the application. The application is acapable of doing all of the tasks you listed above and more. I have found it to be very simple to install and has simple and intuitive user interface and would recommend it.

Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Full disclosure - I'm a consultant with an SAP Channel Partner, consulting and training company.

If all you want is a scheduler, then there are a number of fine tools that do just that.  I personally haven't used CRD, but I have heard very good things about it.

If you want an actual business intelligence solution that has all the scheduling features and more, Crystal Reports Server is the entry level BI platform from SAP. In addition to all of its rich scheduling features, it has a full-featured business intelligence portal that allows users to view and schedule reports on their own, has single-sign on capabilities, several authentication methods (proprietary, NT, LDAP and AD), the ability to use a semantic middle layer for features like dynamic cascading parameters, secure report access through comprehensive logical and functional user group and folder permissions, web services, the ability to integrate live Crystal Reports data into Microsoft Office applications, java-based dashboarding from Crystal Reports and report parts, interactive flash dashboard integration (Xcelsius), etc...

You can download a trial for free here.

If you're interested in purchasing a bundled package directly, you can do so online here, directly from SAP (I have absolutely nothing to do with this sale - it's a direct link to SAP, no referral link, etc... - this is informational only). Resellers may be able to get  you slightly better prices, but there's no guarantee.  Please note, Crystal Reports Server is most likely more expensive than a scheduler like CRD, but it's also a full BI platform, so it's really an apples-to-oranges comparison. The $8995 (USD - I see you're listed as GMT 0)  bundle is great for very small organization and actually includes both Crystal Reports and Xcelsius software, too.

Since you have SAP Business One you should be aware that Crystal Reports Server integrates with it by allowing SAP Business One connectivity.  You might consider contacting your SAP Account Executive and discussing it with him or her.

kevin1983Author Commented:
Thanks all for you help, I think CRD sounds most likely the best option for us but we will test this out along with some others and will look at the SAP crystal reports server  -although we dont need a BI solution as we already have one (Qlikview) and it looks a bit to expensive
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.