Anyone else having same issue as me? We upgraded from Epicor version 9.xx to 10.1.600.5. Some of the reports in Epicor 9 copied over to E10 was custom created in crystal reports using BAQs. In E9, the report took less than 30 seconds to run but in E10, it takes longer than 10 Minutes. I noticed this with few other reports that were written in crystal reports as well.
Anyone have same issue? Any solution?
Thanks,
AL
Compare the timing to the stock version of the report and the SSRS stock
version. If the stock ones run faster then you know it’s your report (RDD
or .rpt file) that needs to be adjusted. If the stock ones take as long
then it could be a system issue.
Unfortunately, there is no stock version. The report was created from scratch using BAQ and passed the data on to crystal reports via Report Designer. The report was created to compare PO unit cost to Standard unit cost. If Standard unit cost for a part is $0, then include in the report else ignore. Currently, using the report to load standard cost from Open POs if the standard cost was not loaded previously.
If you run the BAQ with the same parameters as the report how long does it take to pull back all the data?