Sage 100

 View Only
  • 1.  Crystal Report Windows Viewer error

    Posted 12-28-2022 23:23
    v2016 STD.  In the middle of an upgrade to v2020.  The v2022 client has been installed so I have replaced the pvxwin32.exe.config so that Crystal will run in 2016.

    HOWEVER, there are several CUSTOM Crystal reports that produce this error message when running from the menu.  If I run the report from Designer, I do not encounter the error.  The report runs from the v2022 menu.

    Any thoughts?

    Thanks in advance.




    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------


  • 2.  RE: Crystal Report Windows Viewer error

    Posted 12-29-2022 01:55
    If the report is accessed from inside of Sage, go to the report from Report Manager and verify database.  If it pops up for the verify database, hit the back button until you can pick the Sota MAS90 database.  Save the report and try again.  (This is only a possible resolution.)

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------



  • 3.  RE: Crystal Report Windows Viewer error

    Posted 12-29-2022 07:58
    Thinking it could possibly be the issue with a prompt for a numeric field.  You have to change the prompt to a string, then convert it to a number when using it.

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 4.  RE: Crystal Report Windows Viewer error

    Posted 12-29-2022 08:14

    Great memory Beth!

     

    Jeff,

    Here is a link to the KB article if it helps

    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=89925&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=3035&cmd=displayKC&dialogID=183906&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true

     

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     






  • 5.  RE: Crystal Report Windows Viewer error

    Posted 12-29-2022 08:58
    Thanks.  @Michele Herzog - Great thought.  I forgot to mention I did that as well.  Great minds think alike though.  The prompt formula is great idea. Will give it a look.

    Stay tuned.​

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------