Sage Accpac Community
Accpac Support Community
Search in

Crystal error

Last post Fri, Jul 30 2010 3:24 PM by chiman. 9 replies.
Page 1 of 1 (10 items)
Sort Posts: Previous Next
  • Thu, Jul 29 2010 7:41 PM

    • chiman
    • Top 25 Contributor
    • Joined on Mon, Jun 2 2008
    • Posts 43

    Crystal error

     

    Having a problem with Crystal on new server .Everything is fine on old servers but on this one I have to reinstall Crystal every day. Reinstalled windows and ACCPAC and still same issue.Any ideas?

     

     

    Here is error

    Description: Error in File E:\ACCPAC\OE55A\ENG\OEPICKSHIPMENT1.RPT: Error in formula  <dtShip>.  'pwFormatDate( {OESHIH.SHIDATE}) ' The remaining text does not appear to be part of the formula.

     

    Source:  18:40:07

  • Thu, Jul 29 2010 7:57 PM In reply to

    Re: Crystal error

     I'm guessing the Crystal dll's are not being registered on the new server, that's why you have to reinstall every day.

    What is the server OS? Is it a terminal server?

     

  • Thu, Jul 29 2010 11:17 PM In reply to

    • chiman
    • Top 25 Contributor
    • Joined on Mon, Jun 2 2008
    • Posts 43

    Re: Crystal error

     2003 enterprise with terminal services

  • Fri, Jul 30 2010 5:36 AM In reply to

    Re: Crystal error

    Copy C:\Windows\Crystal\*.* to C:\Windows\System32\

  • Fri, Jul 30 2010 10:50 AM In reply to

    • chiman
    • Top 25 Contributor
    • Joined on Mon, Jun 2 2008
    • Posts 43

    Re: Crystal error

     

    Did try that but no luck

  • Fri, Jul 30 2010 11:07 AM In reply to

    Re: Crystal error

    That's not surprising, because that fix is for older versions of Accpac, when Crystal 8.x was still being used.

    Then Joey is right, Crystal is not getting installed and registered correctly.  You should only have to do it once.  FWIW, nobody else has to install it every day.

  • Fri, Jul 30 2010 2:07 PM In reply to

    • Paul
    • Top 50 Contributor
    • Joined on Thu, Jul 31 2008
    • Posts 13

    Re: Crystal error

    I'm wondering if you have the right version of the Crystal Run Time engine installed because it is my understanding that the "pwFormatDate" function is an Accpac-specific function that is not available in the standard product.

  • Fri, Jul 30 2010 2:15 PM In reply to

    • chiman
    • Top 25 Contributor
    • Joined on Mon, Jun 2 2008
    • Posts 43

    Re: Crystal error

     

    Have professional version. Only difference between this server and other servers is windows 2003 R2 on new server.

  • Fri, Jul 30 2010 2:26 PM In reply to

    Re: Crystal error

    You're confusing Crystal Reports the editor with the Crystal Runtime files that come with Accpac.  Crystal Professional is not required to be installed on the server.  Run Accpac workstation setup with administrative privileges.

  • Fri, Jul 30 2010 3:24 PM In reply to

    • chiman
    • Top 25 Contributor
    • Joined on Mon, Jun 2 2008
    • Posts 43

    Re: Crystal error

     

    Unfortunately no luck

    Edit

    Stupid u2lcapw.dll.

    Just have to copy that dll to system 32 folder and everything is working.....

Page 1 of 1 (10 items)