Sage 100

 View Only

  • 1.  Crystal Logon failure

    Posted 12-03-2020 15:23
    A customer can't print anything from Sage 100 because of an apparent Crystal disconnect.  Their SO Invoices are printing basically a blank format.  All reports come up with the following errors when you either print or preview:
    Print Report Error

    Preview Report Error


    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------


  • 2.  RE: Crystal Logon failure
    Best Answer

    Posted 12-03-2020 15:29
    @Chuck Peddy  If they are using the Sage ODBC print service, stop it and start it again.  ​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 3.  RE: Crystal Logon failure

    Posted 12-03-2020 15:34
    If you have an issue stopping and re-starting the odbc print service you may have to manually end task on it ib task manager.  The program name is pvxiosvr.exe displayed on the details tab of task manager.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 4.  RE: Crystal Logon failure

    Posted 12-03-2020 15:49
    @Doug Higgs  I turned off the ODBC  ​Driver  on tab 5 of the System Configuration and that did the trick!

    Thank you!

    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------

    Original Message


  • 5.  RE: Crystal Logon failure

    Posted 12-03-2020 15:41
    Perhaps someone was playing in ODBC security settings?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 6.  RE: Crystal Logon failure

    Posted 12-03-2020 15:53
    @Kevin Moyes, I wouldn't totally rule that out except this happened in the middle of the day and this is not a technically sophisticated customer.  I may look at things further ​after hours.

    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------

    Original Message


Related Content