Unable to print customized Crystal Reports Pack Slip in 10.2

Epicor ERP 10
1

Hello, we are currently testing Epicor version 10.2 and going through a Quote to Cash scenario. We have customized Crystal reports that are all working in version 10.1. However, in 10.2, when I try to print the customized Pack Slip nothing pops up. If I look in the system monitor, the report shows a status of “ERROR” with the detail message:

“Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Cannot set Column ‘Calc_PackLine’ to be null. Please use DBNull instead.”

Can anyone point me in the right direction on how to fix this? I tried removing the references to Calc_PackLine and then got a different message that they were missing.

Thanks in advance.

2

I should also mention that if I try to preview this is Crystal reports, I get the following error:

“Logon failed.
Details: System.Xml : Unexpected end of file has occurred. The following elements are not closed: ReportDataSet. Line 3015, position 14.”

3

is this a custom report data definition? I had a similar problem before and re-created the entire custom data definition to resolve the issue.

4

Is that Calc_PackLine in the RDD or is it a formula within the Crystal Report?

If it is in the RDD, then yes, you will probably have to rebuild your RDD for this report from the base Packing Slip RDD in 10.2. (That’s usually the case when you upgrade is that the RDDs need to be re-created from the base Epicor-provided ones.)

If the Calc_PackLine is a formula within the CR then I would comment that out and try running the report again. Once you get the XML file to generate you can work on bringing that formula back in and fixing the issue with it within Crystal itself.

I believe your second error (…elements are not closed…) is an issue with the XML file that did not get successfully generated due to the first error that you encountered.

5

Hi Paul,
Thanks for the reply. Yes it is a custom RDD. I was hoping to avoid recreating it from scratch but it looks like that’s the route I may have to go.

I recreated the RDD, and now the report previews but it comes up basically blank. When I pull the xml file into Crystal, I can click browse data on any given field and the correct data is there. Any suggestions for what I could be missing on that end? Did you have to recreate your crystal report from scratch as well? Or just the RDD?

6

The main reason that is most likely happening is because of either record criteria or how you have the database tables linked in the report. For the record criteria part, I would go to the Crystal Report and see if there’s anything in the Reports > Selection Formulas section. For the database table links, make sure that all of the tables are connected by the right fields and that any links that should be an outer join are set up as such. I’ve had problems before where a table link wasn’t set up as an outer join and a record was null in the second table for its related field, so the record wouldn’t show up in Crystal.

1 Like
7

Its been awhile but I think I kept the original Crystal Reports but just had to relinked all the XML.

8

Thanks everyone for the feedback! I didn’t have to recreate the crystal report, but I did have to play with the relation type (output vs definition only) in the RDD. When comparing our RDD from 10.1 to 10.2, I noticed that there were a few relationships where we DIDN’T define the relation type, as it looks like it is not a required field and didn’t seem to matter or affect our results. Anyway, I had left it blank in the new RDD in 10.2 as well since I was trying to match the two, and it seems like filling that out is more important now because as soon as I did, the report populated just fine.