When you attempt to print or preview a report, Epicor 9 submits the request back to the server. The server handles the creation of the report, and asynchronoously sends it back to the client.
If the server can not generate the report, the most common reason being no matching records, it generates and error, and does not inform the client why.
If it seems like your print, or print preview is taking too long, you have to use the Epicor System Monitor taskbar application to find out why. In the bottom right of your Windows Star Bar, click in the Epicor icon. You'll find you report request under eith Active Tasks (if in progress), or History Tasks is it has already failed.
Once you've selected the task for the List tab, click the Details tab to see the error reason:
Type:3
Program:om/sopicklistreport.p
Method:Main-Block
Table:
Field:
Rowid:
Message:No Records Selected.
Had a similar issue today. Reports were stuck at System Monitor / Scheduled Tasks tab, so I couldn't see the error reason.
ReplyDeleteThe solution was restarting the server, I guess the reporting service was down.
Turn on Balloons to see status.
ReplyDeleterestart the epicor task agent from the open edge console management in epicor server
ReplyDeletethe report should be displayed even if there is no record
ReplyDeletei. Restart Epicor Task Agent from Open Edge Console Management in Epicor App Server.
ReplyDeleteIf still not working then do below 2 steps;
Step1:
USE Epicor905
TRUNCATE TABLE sysagenttask
TRUNCATE TABLE sysagenttaskparam
TRUNCATE TABLE sysrptlst
TRUNCATE TABLE systask
TRUNCATE TABLE systaskparam
TRUNCATE TABLE systasklog
TRUNCATE TABLE sysagentsched
Step2:
Restart Epicor Task Agent from Open Edge Console Management in Epicor App Server.