Crystal Reports "Unspecified Error"

This is not  a question, just information:  Recently, Crystal Reports started giving message "Unspecified Error" on certain reports, after working fine for many years. I have determined that there is suddenly an issue between Sage 300 desktop and Crystal Reports, if there is a numeric parameter on the report.  I suspect that this was introduced by a Windows update but not sure about that part.

In any case, the solution is to change the parameter to string and preview the report in Crystal.  It will stop each time it finds that parameter, when it expects a number.  Just wrap the parameter in "tonumber(<whatever it is >)" and the Unspecified Error goes away.  I've had this happen at 3 clients, so the third time, I knew where to look!

Parents
  • Yeah, we saw this over a year ago on some user-written reports. Customized stock reports are all fine, unless you add another non-Sage parameter.  I suspect it's because Sage reports like to have string parameters.  Look inside any xxRPT.INI, even dates are YYYYMMDD strings.

Reply
  • Yeah, we saw this over a year ago on some user-written reports. Customized stock reports are all fine, unless you add another non-Sage parameter.  I suspect it's because Sage reports like to have string parameters.  Look inside any xxRPT.INI, even dates are YYYYMMDD strings.

Children
  • in reply to Jay Converse Acumen

    Thanks for confirming, Jay.  I had one last year and two in the last 2 months.  But my date parameters are working fine; it’s just numbers.  I usually use real date parameters for user input, and then convert them to numbers before using them for selection criteria.  But I can still take a date parameter and pop it onto the report, and it runs fine.  If i do that with a number parameter, even if there is no other reference to it in the report, that’s enough to cause unspecified error.