Schedule Crystal report

Scheduled regular sage 100 rpts work well in task scheduler.

Is there a documented way to schedule a custom crystal report.  Posts I see are many years old so hoping there's an easier solution now.  Have a involved rpt that takes a while to run while people on so would like to have it run at night automaticaly a couple times a week.

Thank you

Parents
  • 0

    Back in my consulting days a client had a report that took 45 minutes to an hour to run. I designed an Access database to pull the data, par it down and then call the Crystal Report it was based on. Took 90 seconds total. 

  • 0 in reply to BigLouie

    CR is great at report formatting, not so much at complex data processing.  I had a report batch that took 18 hours... and moving the joins / logic into SQL Views, it now runs in under a minute (not to mention being so much easier to maintain).

    If the reason for scheduling is report performance BigLouie's recommendation of MS Access (or my preference is SQL Express) to do some of the the heavy lifting can really speed report run times.

Reply
  • 0 in reply to BigLouie

    CR is great at report formatting, not so much at complex data processing.  I had a report batch that took 18 hours... and moving the joins / logic into SQL Views, it now runs in under a minute (not to mention being so much easier to maintain).

    If the reason for scheduling is report performance BigLouie's recommendation of MS Access (or my preference is SQL Express) to do some of the the heavy lifting can really speed report run times.

Children