I have a few crystal reports that uses xml files and sql database as datasource. I have a material queue report that isn’t printing after a server migration. Original XML that was used as the data source is gone for some reason I replaced it with the one generated by epicor when the report is ran.
In Crystal reports it seem to be fine in preview mode. However, when I try to do a print preview in fulfillment workbench the report will not pop up and at system monitor it would just say error and not allow me to highlight and print preview to get the error.
You can often find the System Monitor Errors in the Windows Event Viewer under Applications and Services Logs - Epicor ICE Task Agent Service. Maybe once you can find the detailed error message here it will help you point to the exact issue. The errors anymore are fairly helpful…
Yup, usually when a icon can be activate there is an outline around it when you hover over it but it doens’t seem to be enabled when I highlight the row.
It could be a corrupt .RPT file. Rename it and create a new one one with the old name. Just put anything in the new one (might still need to add the data connection). Just to see if it shows up.
It shows up as report, I also tried to create a blank report with the XML and SQL connections with only one field used in the report and this still happens
That’s just a tiny sample, you should see all of them! Most are “No Records Selected” errors when running BAQ Reports. If anyone has any advice on how to prevent the “No Records Selected” Error event from happening or being logged I’m willing to listen to any advice on how to do that!
I feel like I’m hijacking this thread…sorry peeps!
The mtl Queue report is the only CR based report that is not working. Oth CR based reports work fine.
Using CR Builder (or whatever the CR authoring program is called) to preview the RPT, using recently generated XML data, works fine.
Replacing the RPT file with a basic one (just to show it is being fetched), does not show the basic one when previewed in E10.
Previewing either the desired RPT or the basic RPT show the following in System Monitor:
History tab shows “COMPLETE”
Reports tab shows “System Error has occurred! …” in the Last Action column
With that row selected, the Print and Print Preview toolbar icons are disabled (grayed out)
That all correct?
Do you have the original Epicor version of the Material Queue RPT file? If so point the Report Style to that RPT file and see if it works (I’m assuming you don’t have a custom RDD for this).
That is all correct. The other report styles for the mtl queue report is also working. I don’t think I have the original version of it. Just started working on this project not long ago. Trying to learn everything as I go.
Backing up a second … Is this a built-in report, or a BAQ report?
If built-in, is the RDD the original or a modified one?
There is a chance that the source data in the report you’re trying to print has some bad characters. I recall having certain reports fail to print because the text data had control unprintable characters in it .
Have you tried printing this report with different inputs (selecting a different job or something)? Looked at the XML to see if anything jumps out ?
Here’s the MtlQue.rpt form our old V8 system. If you want try it.
Most are “No Records Selected” errors when running BAQ Reports. If anyone has any advice on how to prevent the “No Records Selected” Error event from happening or being logged I’m willing to listen to any advice on how to do that! 
