Automatically Export Crystal Reports with Schedule

Posted on 2011-05-06
Last Modified: 2012-05-11

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.
Question by:kevin1983
    LVL 4

    Accepted Solution

    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 ...

    Author Comment

    Thanks ill have a look, sounds good
    LVL 100

    Assisted Solution

    A site with several other options

    LVL 19

    Expert Comment


    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.

    LVL 26

    Assisted Solution

    by:Kurt Reinhardt
    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.


    Author Closing Comment

    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

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    This video discusses moving either the default database or any database to a new volume.
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now