Can't tell you without seeing the RPT, it might be a crappy report. Is it slow in Preview, too?

I wondered if it could be the report after I posted this. It's based on the standard Sage 300 OEINV04.rpt. There weren't any big changes, although I did not verify it against the current version Sage 300 2016. They were running Sage 300 2012.

So is it slow in preview or not?

Here's what I did. I verified the form (Crystal Reports > Database > Verify Database). I hadn't done it yet for the new version of Sage 300 2016 - they were running Sage 300 2012. I tested it using PD_PREVIEW and it was much faster.

(I wanted to verify it was actually verify database and not that the office staff cleared out at 5 that caused performance to improve).

I also replaced references to CSCCD.DECIMALS with the number 2 and removed CSCCD from the report this morning.

Response time is 5 - 10 seconds per invoice - much better and acceptable.

Thanks for your input Jay!

Also - remove any sub-reports that you're not going to use. They each add time to the generation of the report.